EQEmulator Forums - Help with MySQL commands

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Help with MySQL commands (https://www.eqemulator.org/forums/showthread.php?t=31416)

Help with MySQL commands

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!

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;

Code:

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).

Thanks for the replies everyone.