[Help! SQL] Set ALL Buy / Sell Price to xx

[Lilltimmy]

I Need the SQL That makes ALL Items on the server cost 10g and Sell Price to 5g

I Know its something like:
update `items` set buyprice= 'xx' set sellprice='xx'

And if there is anything that makes every Bind on Pickup/Equip Become <No Binding>

[b!atch]

Its something like

UPDATE `items` SET `buyprice`='10000',`sellprice`='5000' WHERE (`entry`='between 1 - 999999')

brb. ill go find out

EDIT: just tried that one, it ran. idk if it works ingame. test it and report back

[Power of Illuminati]

UPDATE items SET buyprice = '10', sellprice = '5';

Updated and fixed ;P

[b!atch]

I dont think that'll work illumi

[Lilltimmy]

Tried all of them nothing happened, Modified them a lil' bit heres the Real One that WORKS:

UPDATE `items` SET `buyprice`='10000',`sellprice`='5000';

[b!atch]

Glad you found out about your problem