Select * where "[review]" in subject

[JayRoe]

As the title suggests. How do I phrase this correctly?

Koodi [Valitse] Laajenna

$result = mysql_query('SELECT id_topic, id_board, poster_time, poster_name, subject FROM smf_messages
WHERE id_board IN (' . $use_boards .')
AND "[review]" IN (subject)
');

Basically what I want to do is, find posts that have "[review]" in the subject, without the quotation marks. It works if the subject is "[review]", but if I change the subject to "[review]this game", it stops working.

[rsw686]

SELECT id_topic, id_board, poster_time, poster_name, subject
FROM smf_messages
WHERE id_board IN (' . $use_boards .')
AND subject LIKE '%[review]%'

[JayRoe]

Thank you, that did it.