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 (-)
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
13 freelance font une offre moyenne de $12 pour ce travail
Hey, Use replace function in SQL to repace space with '-' and similarly @ with blank ''. Message me if you still face any issue.
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. Plus
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 Plus
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
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 Plus
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 Plus
I have hands on experience in sql and also done sql data science. Please consider me for your current requirement
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.
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
SELECT REPLACE(REPLACE('Tell us more about your@project', ' ', '-'),'@','-'); Relevant Skills and Experience SELECT REPLACE(REPLACE('Tell us more about your@project', ' ', '-'),'@','-');
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.