Menu
How do you use the "between" function on phpMyAdmin search function?
I've tried
2012-11-29 AND 2012-11-30
and
'2012-11-29' AND '2012-11-30'
and when I press "go" it returns back to this screen. There are definetly results, because if I set the date to = 2012-11-29 I get a result.
288
phpMyAdmin is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating a database, running queries, and adding user accounts.
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.
But perhaps one of the most compelling reasons for using phpMyAdmin is that many hosting companies supply it as the default way to administer MySQL. Used together with a local installation of MySQL, phpMyAdmin makes it easy to test your database structure and queries before going live on the internet.
Well, for normal fields you should use comma to separate values. For example, to include BETWEEN 4 AND 5 clause in your query, just write 4, 5 in that input. In your case entering 2012-11-29, 2012-11-30 should do the trick.
Interestingly, the current version of phpMyAdmin (3.5.1) just doesn't let comma into a datetime column-related input.
119
You need to use , between dates, since the file doesn't let you to enter non-numerical characters, so you can copy , from somewhere else and paste it PHPMyAdmin.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
