已关闭

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

技能: MySQL, PHP, SQL, 数据库管理, HTML

查看更多: 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#

关于此雇主:
( 19个评论 ) Nairobi, Kenya

项目ID: #21707763

13 威客就此工作平均出价 $12

jiteshparwal93

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

$10USD 在1天里
(2条评论)
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. 更多

$10 USD 在7天内
(2条评论)
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 更多

$10 USD 在7天内
(0条评论)
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 在7天内
(2条评论)
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 更多

$15 USD 在2天内
(0条评论)
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 更多

$10USD 在1天里
(0条评论)
0.0
yogeshreddy7991

can do this with REPLACE() function of mysql

$10USD 在1天里
(0条评论)
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 在2天内
(0条评论)
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 在2天内
(0条评论)
0.0
$15 USD 在3天内
(0条评论)
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

$15USD 在1天里
(0条评论)
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 在10天内
(0条评论)
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 在7天内
(0条评论)
0.0