mysql BETWEEN operator
Translation results:
英[bɪˈtwi:n] 美[bɪˈtwin]
prep.Between...; privately, secretly; choose one of...; come and go between...
adv .among, middle
mysql BETWEEN operatorsyntax
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 operatorexample
//以字母顺序显示介于 "Adams"(包括)和 "Carter"(不包括)之间的人 SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'; //以字母顺序显示介于 "Adams"(包括)和 "Carter"(不包括)范围之外的人 SELECT * FROM Persons WHERE LastName NOT BETWEEN 'Adams' AND 'Carter';