How do I query for fields containing a given text in MySQL?

SELECT ... WHERE stuff LIKE 'itunes%';

Here % serves as a wildcard character, so this would match rows with the stuff field equal to any of itunes, itunesfoo, itunes1, …

More info: SQL LIKE Operator at W3Schools.