search records with text mysql/php -

i'm trying search , display records have text.

select * question_attempts `responsesummary`='the compiler report error.' 

it not displaying records. how can records having text?

try it:

where responsesummary '% compiler %'

'compiler' or other words.