table test
id usertype visible
1 animal true
id usertype visible
2 animal true
id usertype visible
3 house true
如何把所有 usertype 是 animal 的 Visible 值改成false?
update test set visible = false where usertype like 'animal'