I have tried the short exercise on pages 287 / 288 - Use only the first Interest.
However, I get a column that returns all Interests in the field not just the first one showing only 'Animals'.
I have double checked and treble checked the SQL code with the book and it seems fine:
SELECT * FROM my_contacts WHERE gender = 'F' AND status = 'single' AND seeking LIKE '%single M%' AND birthday > '1950-08-28' AND birthday < '1960-08-28' AND SUBSTRING_INDEX(interests, ',' ,1) = 'animals';
Thanks Andy ;-)