php - 替换列中内容多的单词

Question

我想知道如何更改 TEXT 列中有很多单词的单词。
例如我有这个

|id|             content             |
| 1| my name is alpha root i like .. |
| 2| i need your help am alpha root  |
| 3| Today i was with alpha root     |

我想要一个可以帮助我将内容中的 alpha 更改为 beta 并保留其他内容的查询。
变成那样

|id|             content             |
| 1| my name is beta root i like ..  |
| 2| i need your help am beta root   |
| 3| Today i was with beta root      |

我研究了很多但没有结果

Answer 1

UPDATE your_table
SET your_field = REPLACE(your_field, 'alpha', 'beta')
WHERE your_field LIKE '%alpha%'

来源:http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace