Mysql query to select from multiple ranges

Question

I need some help. I've tried to search for the answer without success/

I need to select records from a table by price field which value must be in one of the ranges. Let me explain

select * from items 
    where color = 'black'
    AND shape = 'square'
    AND price between 333 and 444
    OR price between 777 and 888

But this will ignore color and shape conditions. What is the correct syntax for that? Is this a correct approach at all?

Thanks!

juergen d · Accepted Answer · 2015-10-30 08:52:00Z

1

and has a higher operator precedence than or. You need parentheses to manage that

select * from items 
where color = 'black'
AND shape = 'square'
AND 
(
   price between 333 and 444
   OR price between 777 and 888
)

answered Oct 30, 2015 at 8:52

juergen d

205k40 gold badges303 silver badges376 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kostiantyn Over a year ago

Thanks. That was a problem.

Venkatesh Panabaka · Accepted Answer · 2015-10-30 08:52:23Z

0

I think below useful to you. please check it once.

 select * from items 
        where color = 'black'
        AND shape = 'square'
        AND ((price between 333 and 444)
        OR (price between 777 and 888))

answered Oct 30, 2015 at 8:52

Venkatesh Panabaka

2,1644 gold badges21 silver badges27 bronze badges

Collectives™ on Stack Overflow

Mysql query to select from multiple ranges

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related