Searching records where the comments column contains the keyword 'Smith'...'
SELECT * FROM `user` WHERE lastName LIKE '%Smith%'
The number of retrieved records is: 6
John Smith
Will Smith
Frank Smith
Frank Smith
Frank Smith
Frank Smith
Search finished