Replace command & backslash
Posted by: Mauro Miotello
Date: November 16, 2014 03:03AM

I'm using MySql 5.6 on CentOS 6.5 and i need to change backslash chars in some columns of my table. I've found some errors so i've decided to test replace command with simple string:

SELECT REPLACE('ashnet.it\maurizio\', '\', '/'); -> error 1064

SET sql_mode = NO_BACKSLASH_ESCAPES;
SELECT REPLACE('ashnet.it\maurizio\', '\', '/'); -> no error but no replace done

SELECT REPLACE('ashnet.it\maurizio\*', '\', '/'); -> replace done !

someone know why adding * the replace is done ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replace command & backslash
3995
November 16, 2014 03:03AM
1400
November 17, 2014 12:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.