Help with MySQL commands

[reddogut]

Can someone help me with the syntax on a couple MySQL commands?

I want to reset the hit points on all mobs/NPC's within a set level range. For example all mobs/NPC's between levels 1 and 10 get set to 10 hit points.

UPDATE npc_types SET HP = 10 WHERE LEVEL ??????

I want to be able to search the items table for all items containing a set of characters. For example, I want to search for all items with the word 'boots' in the name.

SELECT * FROM items WHERE NAME = 'boots';

But I know that = doesn't work unless I have the exact name, like 'steel toed boots'.

Thanks!

[Andrew80k]

Now this is UNTESTED and since I don't have the table definitions in front of me I can't guarantee that this is correct. This is the syntax for updating a range.

UPDATE npc_types SET HP = 10 WHERE LEVEL >= 1 and LEVEL <= 10;

[pfyon]

select * from items where name like '%boots%';


The % act as wildcards. Also note that if your mysql db is on a linux system, the names will be case sensitive (so boots would match 'Journeyman's boots' but not 'Journeyman's Boots' for example).

[reddogut]

Thanks for the replies everyone.