select * from TABLE where TABLE.key like '%search string%'

is the general form. If you give me your table structure and keys you need and I can write the query for you.

Cheers,
Kalayama