MySQL: Multiple AND queries with using BETWEEN?

Question

I had seen a colleague use this to fetch users from a table under these conditions:

SELECT * FROM users WHERE gender ='male' 
AND activated='yes' 
AND date_registered BETWEEN '$date1' AND '$date2'

He said there was an problem (it not outputting any rows when the AND activated='yes' was put there as well, but no MySQL error was thrown.

Can you not do this? Do you need to put it in brackets or something crazy to associate the BETWEEN and AND?

Dates are in correct format by the way.

My first guess is that no rows matched the query in that case... — JoshD
– JoshD, Commented Oct 5, 2010 at 19:21

Wrikken · Accepted Answer · 2010-10-05 19:20:26Z

7

Nope, it will work just fine. However, you might want to format your query so it is clear which AND is standalone, and which belongs to a BETWEEN .. AND ... statement:

SELECT * FROM users 
WHERE gender ='male' 
   AND activated='yes' 
   AND date_registered BETWEEN '$date1' AND '$date2'

answered Oct 5, 2010 at 19:20

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

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

1 Comment

John Over a year ago

I will mention that to him for further tasks, I'll accept your answer after I get back from work, I need to go!

p.campbell · Accepted Answer · 2010-10-05 19:19:56Z

4

No brackets required. You've got the correct syntax.

answered Oct 5, 2010 at 19:19

p.campbell

101k70 gold badges264 silver badges326 bronze badges

1 Comment

John Over a year ago

Thanks you, that makes it easier to explain.

Collectives™ on Stack Overflow

MySQL: Multiple AND queries with using BETWEEN?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related