SQL for BETWEEN

[Peter3]

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]

hmm I think you want to edit values in a specific range? what are those 1 and 2 supposed to be?

[Peter3]

hmm I think you want to edit values in a specific range? what are those 1 and 2 supposed to be?

a_index

[Wizatek]

It works like this :

 

SELECT * FROM t_npc WHERE a_index BETWEEN 1 AND 10;

[Peter3]

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]

UPDATE t_npc SET a_attack_ = "something" WHERE a_index BETWEEN 1 AND 10;