Cerrado

How do i generate url from title column?

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

Habilidades: MySQL, PHP, SQL, Administración de bases de datos, HTML

Ver más: how generate targeted leads, how generate leads, how generate leads for free, how generate leads towards doctors, how to add cost column in ms project, how long will the robot try to find an uielement (if it is not available) on the desktop, how to split one column into multiple columns in excel, how to read a column from csv file in python, how to copy a column in excel to another sheet, how to copy a column from a pdf, in excel, how to sort a column and keep respective values in other columns, how to convert excel column to comma separated list, how to split one column data into multiple columns in sql, how to split one column into multiple columns in access, sharepoint list change title column, how to duplicate a column in google sheets, how to edit a column in sharepoint, how to build an app without coding knowledge, how to insert a column in excel, how to add new column with value to the existing datatable in c#

Información del empleador:
( 19 comentarios ) Nairobi, Kenya

Nº del proyecto: #21707763

13 freelancers están ofertando el promedio de $12 para este trabajo

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 en 1 día
(2 comentarios)
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. Más

$10 USD en 7 días
(2 comentarios)
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 S Más

$10 USD en 7 días
(0 comentarios)
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 en 7 días
(2 comentarios)
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 tab Más

$15 USD en 2 días
(0 comentarios)
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 Más

$10 USD en 1 día
(0 comentarios)
0.0
yogeshreddy7991

can do this with REPLACE() function of mysql

$10 USD en 1 día
(0 comentarios)
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 en 2 días
(0 comentarios)
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 en 2 días
(0 comentarios)
0.0
$15 USD en 3 días
(0 comentarios)
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 en 1 día
(0 comentarios)
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 en 10 días
(0 comentarios)
0.0
manisreedharan

proper [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] quality.

$10 USD en 7 días
(0 comentarios)
0.0