How do i generate url from title column?

$10 USD

Lukket

Slået op

over 4 år siden

$10 USD

Betales ved levering

I have a mysql table with two columns: Title and url. The url should be from title, and can be created by removing spaces and all characters including spcial characters, then replacing thme with hypens (-) For example If the title column is: Tell us more about your @project" Then Url column becomes: Tell-us-more-about -your-project Somebody please tell me an sql statement i can use to do that I just need help for anyone willing to share the knowledge. Please post in ur proposal so i can try

MySQL

PHP

SQL

Database Administration

HTML

Projekt-ID: 21707763

Om projektet

13 forslag

Projekt på afstand

Aktiv 4 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

13 freelancere byder i gennemsnit $12 USD på dette job

@jiteshparwal93

Hey, Use replace function in SQL to repace space with '-' and similarly @ with blank ''. Message me if you still face any issue.

$10 USD på 1 dag

5,0

(2 anmeldelser)

3,3

@DataOnMatrix

Greetings, i can help you with the removing of spaces and all characters including special characters, then replacing them with hyphens (-).Please connect over chat to discuss it in detail and allow me to work on it. I have 8 years of experience with web; javascript, Jquery, css, html, mvc, php, laravel and angular as well as c#. Working with a number of db schema's involving SQL,MY/MS SQL, no SQL. Many thanks, MG

$10 USD på 7 dage

5,0

(2 anmeldelser)

2,8

@Henry788

Hello, I have More than Five years (6+ years) of experience in Professional Software Development. Seeking for a challenging position as a Java Developer with the strong working experience in programming, designing of Spring, Hibernate, CORE JAVA / J2EE application,JavaFX and Swing base desktop application. Develop applications using Spring MVC using Annotations, Spring Boot, Spring Cloud,Python,Go....

$10 USD på 7 dage

0,0

(0 anmeldelser)

0,0

@gabianton2018

Welcome to your job post. Your requirement can be done by few lines sql. I am very familiar with MySQL SP(stored procedure). I can do it within few hours. Please contact me. best regards. gabi

$10 USD på 7 dage

5,0

(2 anmeldelser)

0,0

@MidoYousef

I’ve worked in sql as trainer And I can help and do the mission Just show me the table and your needs And I’ll do the rest :) Relevant Skills and Experience Programmer, data base builder, type writer, excel and tables expert, writer

$15 USD på 2 dage

0,0

(0 anmeldelser)

0,0

@bindalvaishali

Hi, Mysql does provide you with a replace function where you can replace anything with anything it works as : replace(field_to_be_replaced , what should be replaced, by whom should be replaced) Please search replace in mysql and i can help you do the same as well if you accept my proposal. :)

$10 USD på 1 dag

0,0

(0 anmeldelser)

0,0

@yogeshreddy7991

can do this with REPLACE() function of mysql

$10 USD på 1 dag

0,0

(0 anmeldelser)

0,0

@klogambigaiuk

I have hands on experience in sql and also done sql data science. Please consider me for your current requirement

$15 USD på 2 dage

0,0

(0 anmeldelser)

0,0

@SandipDervaliya

Hi There, I am php developer, i can understand this and i try my best fulfill your requirement.I deliver your project in your time.

$10 USD på 2 dage

0,0

(0 anmeldelser)

0,0

@ThepanchMX

Please put an input and result example in order to give you a working sql sentence. What special characters do you need to replace? There are a lot of them, anything but a-z,A-Z,1-0? I’ll give you a working one

$15 USD på 1 dag

0,0

(0 anmeldelser)

0,0

@freelancer101019

SELECT REPLACE(REPLACE('Tell us more about your@project', ' ', '-'),'@','-'); Relevant Skills and Experience SELECT REPLACE(REPLACE('Tell us more about your@project', ' ', '-'),'@','-');

$15 USD på 10 dage