a Navicat question->Sellprice

[secretdragon008]

i dont need the list anyway Illidan1,i just found a very easy code to change all the items sellprice, i just put this in Query:
UPDATE items SET sellprice = 1 ,and then run.
then all the items have the sellprice 1.

[latruwski]

lol why making it that hard illidan1?

just use this:

UPDATE `items` SET `sellprice`='0' WHERE 'sellprice' <> '0';

or even more simple:

UPDATE `items` SET `sellprice`='0'

grtz

[latruwski]

ah posted a few minutes to late.. (topic was not updated with your post yet when i posted xD )

gtz

[secretdragon008]

ah posted a few minutes to late.. (topic was not updated with your post yet when i posted xD )

gtz

Its okey