UPDATE (表明)
SET 字段名=REPLACE(段,'休息室','值班室')
WHERE 条件 in (1,2)
注:修改的是字符串
示例:
UPDATE user
SET house=REPLACE(house,'休息室','值班室')
WHERE id in(31215,31216)
UPDATE (表明)
SET 字段名=REPLACE(段,'休息室','值班室')
WHERE 条件 in (1,2)
注:修改的是字符串
示例:
UPDATE user
SET house=REPLACE(house,'休息室','值班室')
WHERE id in(31215,31216)