[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!