How do i generate url from title column?

$10 USD

已关闭

已发布

超过 4 年前

$10 USD

货到付款

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

项目 ID: 21707763

关于此项目

13提案

远程项目

活跃4 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

13威客以平均价$12 USD来参与此工作竞价

@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 在1天之内

5.0

(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. 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 在7天之内

5.0

(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 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 在7天之内

0.0

(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天之内

5.0

(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 tables expert, writer

$15 USD 在2天之内

0.0

(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 in mysql and i can help you do the same as well if you accept my proposal. :)

$10 USD 在1天之内

0.0

(0条评论)

0.0

@yogeshreddy7991

can do this with REPLACE() function of mysql

$10 USD 在1天之内

0.0

(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条评论)

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条评论)

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 在1天之内

0.0

(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天之内