SELECT `contact`.* FROM contact WHERE (contact.lastname LIKE '%gra%' OR SOUNDEX(contact.lastname) LIKE SOUNDEX('gra') OR contact.firstname LIKE '%gra%' OR SOUNDEX(contact.firstname) LIKE SOUNDEX('gra') OR contact.company LIKE '%gra%' OR SOUNDEX(contact.company) LIKE SOUNDEX('gra')) LIMIT 0,10