Results 1 to 2 of 2
Jan 9, 2006, 22:25 #1
any of the 3 Skills can equal 'Juggling' (was "MYSQL query")
I have a table (users) with the following columns:
For this example, let's say I want to run a query for all users where Name equals "John" and any of the 3 Skills can equal "Juggling"
$query = SELECT * FROM users WHERE Name = 'John' AND (Skill1 = 'Juggling' OR Skill2 = 'Juggling' OR Skill3 = 'Juggling') ORDER BY...
The parenthesis seem to be ignored in this query. Is there another way to do this?
Jan 9, 2006, 22:33 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 59 Post(s)
- 3 Thread(s)