Need help with npc_trainer sql query

[bergis1337]

Hello!, im trying to make a sql query that sets the spellcost to 0 of the npc with entry 26332 between the reqlevel 1-59 but i dont get it to work.. i tought it would be like:

UPDATE `npc_trainer` SET `Spellcost` = '0' WHERE `entry` = 26332 `reqlevel` between `1` and `59`

someone help me please!

[stoneharry]

Try:

UPDATE `npc_trainer` SET `Spellcost` = '0' WHERE `entry` = 26332 AND `reqlevel` BETWEEN 1 AND 59;

[bergis1337]

it worked fine to execute but the spells from level 1-59 in that trainer still costs money :/

[stoneharry]

Did you restart the server and has the data in the table been updated?

SELECT * FROM `npc_trainer` WHERE `entry` = '26332' AND `reqlevel` BETWEEN 1 AND 59;

[bergis1337]

yeah i got it working now had to change it to between 0 and 59 since there was some spells that didnt req any level hehe i didnt notice that ^^, anyway thanks alot stoneharry!