mysql - 带选择的 SQL 更新元组

Question

update review set content = "Perfect place to eat" or "WOW" WHERE rating = 5.0;

如何在选项中使用或随机设置某些内容？

这是错误:

1292 Truncated incorrect INTEGER value: 'Perfect place to eat'
1292 Truncated incorrect INTEGER value: 'WOW'

Answer 1

您可以使用rand():

update review
    set content = (case when rand() < 0.5 then 'Perfect place to eat'
                        else 'WOW'
                   end)
    where rating = 5.0;

如果你有多个字符串，你可以这样做:

update review
    set content = (case floor(rand() * 3)
                      when 0 then 'string1'
                      when 1 then 'string2'
                      when 2 then 'string3'
                   end)
    where rating = 5.0;