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