Using two BETWEEN statement

Can you use two BETWEEN statments in a mysql database query....every time i try i get an error.

 

Yes you can, but it may not necessarily be the best alternative.
How does the query look that gives errors?
Easier to help when you can see it

 

$sql = "SELECT * FROM diamonds
WHERE carat BETWEEN 1 AND 2
WHERE girdle BETWEEN 58 AND 60 ";

 

Not sure on this (depends on whether it's Oracle or MySQL, but here are two things to try, alone and combined).

Add a semi-colon after the second and third lines, and remove the quotations. Add an AND to the beginning of the third line.

Let me know if none of those work.

 

$sql = "SELECT * FROM diamonds
WHERE carat BETWEEN 1 AND 2
AND girdle BETWEEN 58 AND 60 ";

 

for performance you can better not user a * in your query

 

Could also be an 'OR' as well as an 'AND'. Depending on what you are going for, of course.

 

you can use multiple BETWEEN (from my tests). If used on the same field, il will give you the intersection or the two between

if used on two different fields it works like a charm!