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
can have 'ja' in them, use the OR.
Jennifer Horne
Panda Voice Systems Inc.
1.888.767.2632 ext 23
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 22, 2004 9:41 AM
To: [EMAIL PROTECTED]
Subject: (simple select) bug? version problem? or just bad SQL