I have a column that i would like to update but having some problems..It contains information like the following:
"Brand-name portable power for ipod(r), iphone(r), blackberry(r), android(r) & other usb charged devices"
I want to be able to remove or update the '(r)' and have it replaced with the html code '®' so that the browser will know how to push it to the screen. I`m using the following queries and getting 0 rows when updating..
I run this statement and get results:
SELECT * FROM `tbl_name` WHERE `col_name` Like '%(r)%'
But when i run the update statement i get 0 rows updated:
update tbl_name set `col_name` = replace(`col_name`,'(r)','®') where `col_name` Like '%(r)%'
Am i missing something here?
Thanks in advance