我想把SQL数据库中的一个表中的某列的部分数据替换成同一个数值的命令是什么呀？[我是新手，刚学习的]

[wangbin818]

SELECT *, loc AS Expr1 FROM t_company WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')
*---上面为我要更改的表为t_company中的loc列中的部分数据---------*
如果我要把这部分查询出来的loc列数据全部改成90要怎么改呀？

[lizhaogui]

UPDATE t_company set loc ='90' WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')

[云中客]

update Expr1 set loc=90 WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')

[云中客]

不好意思上面表名写错了
如果loc为字符型
UPDATE t_company set loc ='90' WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')

如果loc为数值型
UPDATE t_company set loc =90 WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')

[子陌红尘]

update t_company set loc = '90' WHERE (loc = '=') OR (loc = '27') OR (loc = '28') OR (loc = '29') OR (loc = '30') OR (loc = '31') OR (loc = '32') OR (loc = '33') OR (loc = '34')

[wangbin818]

谢谢各位的帮忙了。