mysql BETWEEN operator

英[bɪˈtwi:n] 美[bɪˈtwin]

prep.Between...; privately, secretly; choose one of...; come and go between...

adv .among, middle

mysql BETWEEN operator syntax

Function:Select the data range between two values. These values ​​can be numeric, text, or dates.

Syntax: SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2

mysql BETWEEN operator example

//以字母顺序显示介于 "Adams"（包括）和 "Carter"（不包括）之间的人
SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter';
//以字母顺序显示介于 "Adams"（包括）和 "Carter"（不包括）范围之外的人
SELECT * FROM Persons WHERE LastName NOT BETWEEN 'Adams' AND 'Carter';