item editing through MySql

[klinzhai]

I usually just use MySQLCC, select the table, click on the 'SQL' button (for sql queries). Then I enter:

SELECT * FROM 'items' where ac >= 75;

That brings me back a list of 196 items, then I can search for the item that I want. You can also do the following (if you know the name of the item):

SELECT * FROM 'items' where name = "Thick Basilisk Hide Shield";

Then you scroll over to whatever you want to edit and make it whatever you want it to be. The only bad thing about MySQLCC is that if you try to return more than a few thousand items it kinda bogs down. Even with the 1GB of RAM on my laptop.