当其他两个中有特定文本时，MySQL 更新列中的值

Question

我有 phpmyadmin 页面，我必须更改数据库中的许多行。我有表“lime_answers”，里面有answer 和language 列。我想要做的是更新所有答案，让我们说“littlepony”到“bigpony”，但只有当语言列在该行中有“en”时。所以像

SELECT * FROM 'lime_answers' WHERE ('answer' = 'littlepony' AND 'language' = 'en') 
then SET 'answer' = 'bigpony'

这可能吗？

Answer 1

Try this


 update 'lime_answers' set 'answer' = 'bigpony'
    where ('answer' = 'littlepony' AND 'language' = 'en')