Hi, I am running this (simple?) query on mysql 3.23 : select * from clients_tb where active='on' AND first_name LIKE '%ja%' AND middle_name LIKE '%ja%' AND last_name LIKE '%ja%'";
I know there are people in the table with: first name James last name James middle name Jacob etc but it does not display them...if i try with just first name then it displays the people whose first names start with "ja" whats wrong? is this a bug or not supported in 3.23 or I have written bad SQL? How can I do the above? Thanks, -Ryan A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
