PROBLEM:
How to Replace in mysql?
SOLUTION:
If you have a table in my sql database which having '(' ')' or any other character and you want to replace it then use as:
UPDATE tble_nm SET taluk = REPLACE(taluk, '(', '') WHERE taluk LIKE '%)%'
How to Replace in mysql?
SOLUTION:
If you have a table in my sql database which having '(' ')' or any other character and you want to replace it then use as:
UPDATE tble_nm SET taluk = REPLACE(taluk, '(', '') WHERE taluk LIKE '%)%'
0 comments:
Post a Comment