SQL Query Help please

[dew1960]

Hello again!

I am beginning to learn to write my own querys for MySQL and I tried this to select all items from the database that have the word 'defiant' in the name.


Here is what I tried:

 

SELECT "*" FROM items WHERE name LIKE 'crude defiant *';

It isn't working so I am asking how to do this properly.

Next I want to set sellrate to a number like '3'

(I have some custom vendors set up to sell Defiant armors but the sell rate is like 60 or higher and my players can not afford to buy it at lower lvls.
If I lower the sell rate, it will be easier for them.

I don't want to set it to the same number for all items, just the defiant stuff and then a different rate for each type of defiant gear.

Example: sellrate =1 for 'Crude Defiant *', sellrate = 2 for 'Simple Defiant *', etc. I will have to do like trial and error to see how it works out in game. I can figure all that out and edit the # to input in the sell rate field, if I can just get the basic query above in the correct format, LOL.

Thank you so much for helping me with this if you will be so kind.

dew1960
(SQL Dummy)

P.S. - Is there some way to edit a group of items like that in an editor like GeorgeS Item Editor or some other editor?