Discuss WHERE column BETWEEN 'd' AND 'f' in the MySQL Help forum on Dev Shed. WHERE column BETWEEN 'd' AND 'f' MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Time spent in forums: 5 Months 2 Weeks 2 Days 4 h 10 m 15 sec
Reputation Power: 9259
No, it means to find items where the name sorts between the strings "d" and "f". That includes "e", "d" and "f" (because BETWEEN is inclusive), "demographic", and "elliptical", but it does not include "fluoride" (because it sorts after "f").
Additionally, if you're using a case-sensitive collation (which you can tell by checking if the collation is binary or its name ends in "cs") it will not include "Demographic".