want know how can change word in column text have words.
example have
|id| content | | 1| name alpha root .. | | 2| need alpha root | | 3| today alpha root |
i want query can me change alpha
beta
in content , keep other things.
become
|id| content | | 1| name beta root .. | | 2| need beta root | | 3| today beta root |
i have researched lot no results
update your_table set your_field = replace(your_field, 'alpha', 'beta') your_field '%alpha%'
source : http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace
Comments
Post a Comment