[SOLVED] MySQL || Operator

[centenial]

Hi,

I have a MySQL || OR operator question. Here's my query:

SELECT
id, name
FROM
images
WHERE
userid = '1' AND
(field1a > 100) || (field1b > 100) AND
(field2a > .2) || (field2a > .2)

I want to select all records from the image table where userid = '1', where either field1a or field1b are greater than 100, and where field2a or field2b are greater than .2.

The query as it is pulls the records for all users from the database, not just the ones for user1. Help anyone?

[paul2463]

try putting the OR statemenst into more brackets

SELECT id, name FROM images WHERE userid = 1 AND ((field1a >100)||(field1b > 100)) AND ((field2a >.2)||(field2b > .2))

[centenial]

Thanks, that works great!