Use function between phpMyAdmin

Question

How do you use the between function in the phpMyAdmin search function?

I tried

2012-11-29 AND 2012-11-30 

and

  '2012-11-29' AND '2012-11-30' 

and when I click go, it returns to this screen. There are certain results, because if I set the date to = 2012-11-29 , I get the result.

Answer 1

Well, for normal fields, you should use a comma to separate the values. For example, to include the BETWEEN 4 AND 5 clause in your query, simply write 4, 5 in this entry. In your case, entering 2012-11-29, 2012-11-30 should do the trick.

Interestingly, the current version of phpMyAdmin (3.5.1) simply does not allow commas to enter data associated with the datetime column.

Answer 2

You need to use , between dates, since the file does not allow you to enter non-numeric characters, so you can copy , from another place and paste it into PHPMyAdmin.