>> Sticking with the May example... I would like to be able to return >> results for only students named May or Maya, but not Mayra, Jessica-May, >> or Maylita.
SELECT * FROM students WHERE first_name LIKE 'May_' _ in like means any single character % in like means arbitrary number of characters (including zero number) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
