Home > Article > Backend Development > Talk about the between_PHP tutorial on sql query
Talk about the between_PHP tutorial on sql query
- WBOYOriginal
- 2016-07-13 17:00:52779browse
Author: Ah Liang
Published in ASP Zone, 2000-11-25 21:42
Example 1: Find the student number and age of students between 20 and 22 years old (including 20 and 22)
select number,age
from s
where age between 20 and 22
Example 2: Find the student number and age of students who are not between 20 and 22 years old
select number,age
from s
where age not between 20 and 22
Note: between is followed by a low value, and is followed by a high value!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：A little experience in using medium-sized Access database for a long time_PHP tutorialNext article：A little experience in using medium-sized Access database for a long time_PHP tutorial