+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: General Section (https://lckb.dev/forum/forumdisplay.php?fid=216)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=120)
+---- Thread: Help Sql Statement (/showthread.php?tid=4271)
- CDWriter - 12-25-2014
could some give me a working statement that checks a_item_percent_0 compares it to see if its above 10000 and if it is replace it with 10000... but leave all other values below 10000 alone ...
ive tried many ....but not a sql Guru as some ...
Does not work.
Select a_item_percent_0 FROM t_npc where a_item_percent_0 >= '10000' set a_item_percent_0 = a_item_percent_0 10000
;
- peter3301 - 12-25-2014
update t_npc SET a_item_percent_0 = 10000 WHERE a_item_percent_0 > 10000;