SharkBait Posted September 26, 2007 Share Posted September 26, 2007 I am needing to do a string replace on in a mysql database on a particular field and I am not sure what the best way about it is. This is my query for updating a field with a REPLACE(): UPDATE Units SET Full_SN = REPLACE(`Full_SN`, 'TR-CPQACN', '') WHERE Real_Date >= '2007-09-25 00:00:01' AND Real_Date <= '2007-10-25 23:59:59' AND Series = 'TRCPQ' AND `MOD` = '16cit' AND ID = 223766 It doesn't update any rows, am I doing the REPLACE() part properly? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 26, 2007 Share Posted September 26, 2007 Try that replace() on the equivalent SELECT query, with the column before and after the replace. Quote Link to comment Share on other sites More sharing options...
SharkBait Posted September 27, 2007 Author Share Posted September 27, 2007 So if I use SELECT and not UPDATE, the SELECT will replace the value in the database with what I want as well as output it? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 27, 2007 Share Posted September 27, 2007 No, but then you'll be able to troubleshoot it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.