MySql Replace word by SQL Query
Posted by Jeevan on 14 January, 2010
No comments yet
This item was filled under [ Tips ]
Do you know that You CAN replace MySql field values by SQL query? it’s pretty simple. Use update Command with “replace” to set value to field:
UPDATE table_name SET table_field = REPLACE(table_field,’replace_string’,'with_this_string’);
Not only this, you can do whole lot of other things without having to write any programes (php, asp etc) to do some trick with [...]