Query BETWEEN dates error

[netfrugal]

I've been getting an error in PhpMyAdmin when I query between dates.
Below is the query I am trying to run:

SELECT * FROM customer 
WHERE CRMGUID IS NULL 
AND BETWEEN dateCreated "2007-02-02" AND "2007-02-09"

this is the error I am getting:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN dateCreated "2007-02-02" AND "2007-02-09"

LIMIT 0, 30' at line 1

Then I tried switching the BETWEEN with dateCreated like this:

SELECT * FROM customer 
WHERE CRMGUID IS NULL 
AND dateCreated BETWEEN ‘2007-02-01’ AND ‘2007-02-05’

And received this error:

#1054 - Unknown column '‘2007' in 'where clause'

I am sure it is a simple syntax error on my side, but I haven't been successful finding it.

Any thoughts?

[cgraz]

BETWEEN comes after your column name. So you'll need to change

AND BETWEEN dateCreated

to

AND dateCreated BETWEEN

Edit: Just saw your post. Try using single quotes around your dates rather than backticks.

[netfrugal]

yes, I tried that in the second example. I was updating the topic at the same time you replied to me.

for some reason I still get an error when I state: AND dateCreated BETWEEN

[bradgrafelman]

In the query you showed us above, there are curly quotes ( ‘ and ’ ) instead of regular single quotes ( ' ). Enclose the date in normal single quotes.