Yes you can, you use LIKE. Just remember that % is a wildcard,
not *.
[sql]SELECT db.table.column FROM db.table
WHERE db.table.column2 LIKE '%Member of the Month%';[/sql]
Just don't use this on large tables since it will cause a huge table scan. And avoid using wildcards at the beginning so MySQL can use the index on that column (if there is one).
You can also use regular expressions in MySQL, just use REGEXP followed by the expression.
Docs:
http://www.mysql.com/doc/S/t/String_...functions.html