MySQL query problem

I have a table setup with various records, some of which contain text like "here's a test".

I am trying to perform a search in PHP using a command set as:
SELECT * FROM my_table WHERE field_name='here\'s a test'

But it isn't working (i.e. no records are returned). From the books I've read etc this should work.

Regards

Andrew Blee.

use "WHERE field_name LIKE '%your text here%'"

note the % sign in front of and behind the entered search text.

-Paul