[RESOLVED] Using BETWEEN 2 dates

[netfrugal]

I can't figure out what I'm doing wrong with the BETWEEN statement:

SELECT * FROM transactions BETWEEN dateCreated = '2007-05-01' AND dateCreated = '2007-05-23' 

I'm sure it's a quick fix

[netfrugal]

figured it out, this is the correct statement:

SELECT * FROM transactions BETWEEN dateCreated = '2007-05-01' AND '2007-05-23'

[NogDog]

netfrugal wrote:

figured it out, this is the correct statement:

SELECT FROM transactions BETWEEN dateCreated = '2007-05-01' AND '2007-05-23'

Really? I would have thought you wanted:

SELECT * FROM transactions WHERE dateCreated BETWEEN '2007-05-01' AND '2007-05-23'

[bradgrafelman]

Me too, since that's the proper syntax according to the MySQL manual page.

Don't forget to mark this thread resolved.

[netfrugal]

Both of you are correct. I copied the wrong syntax. My fault! Thanks for correcting me! This helps everyone else!.