If you are wanting to find the entire length of a string contained anywhere within the words you would need to use a % wildcard surrounding the name you want to find. Use this query instead:
SELECT * FROM items where Name like '%Crude Defiant%';
This will return all items containing the words Crude Defiant. After that you can add in whatever extra you want, just make sure your surrounding the string with the % wildcard.
Edit::
I forgot to add in for setting the sell rate as well. You would just adjust your parameters as well for whatever you want your sell rate to be for the gear. Your generic statement would be:
Update items set sellrate = 1 where Name like '%Crude Defiant%';
Update items set sellrate = 2 where Name like '%Simple Defiant%';
and so forth.
I would honestly suggest just adjusting your price for the items though. The price is expressed in copper pieces and just know that 1000 CP = 1 PP. So using this method say I wanted all Crude Defiant gear to cost someone 50 platinum each piece. 50 x 1000 = 50,000 so you would input into the query:
Update items set price = 50000 where Name like '%Crude Defiant%';
If you wanted to set the weapons to a different price than the armor you could alter your statement to something like:
Update items set price = 60000 where Name like '%Crude Defiant%' and damage > 0;
This would target only the Crude Defiant weapons as they contain a damage amount. There are many ways to alter the statement to target only the particular group you want effected.
You can tweak it from here.
|