Actually dclamp, he wants to search for every record with the first name of john so drop off the LIMIT 1.
Also when you do pattern matching you use LIKE not =
http://dev.mysql.com/doc/refman/5.0/...-matching.html

So....
SELECT * FROM `family` WHERE FirstName LIKE '%john%'