Shulou(Shulou.com)06/01 Report--

Between and contains boundary values in Mysql data query statements

You can use between in the sql statement of MySQL to limit the scope of a data, for example:

Select * from user where userId between 5 and 7

The user,userId range of query userId 5, 6 and 7 contains boundary values, which is the same as the following query:

Select * from user where userId > = 5 and userId =,

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.