+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: SQL for BETWEEN (/showthread.php?tid=3276)
- Peter3 - 01-15-2014
Hi,
how can i edit things with the between command?
i try this, UPDATE t_npc SET a_attack_ = a_attack /2 BETWEEN 1 AND 2;
- Wrong - 01-15-2014
hmm I think you want to edit values in a specific range? what are those 1 and 2 supposed to be?
- Peter3 - 01-15-2014
hmm I think you want to edit values in a specific range? what are those 1 and 2 supposed to be?
a_index
- Wizatek - 01-15-2014
It works like this :
SELECT * FROM t_npc WHERE a_index BETWEEN 1 AND 10;
- Peter3 - 01-15-2014
It works like this :
SELECT * FROM t_npc WHERE a_index BETWEEN 1 AND 10;
yes, but i want to edit the attack in the same sql.
- Sutz - 01-15-2014
UPDATE t_npc SET a_attack_ = "something" WHERE a_index BETWEEN 1 AND 10;