Home > Database > Mysql Tutorial > body text

What does and mean in mysql

WBOY
Release: 2021-12-01 18:46:59
Original
5836 people have browsed it

In mysql, and means "and", which is used to combine two or more conditions in the WHERE substatement; when using the and keyword, records that meet all conditions will be returned. If any of the conditions are not met, such records will be excluded.

What does and mean in mysql

The operating environment of this tutorial: windows7 system, mysql8.0.22 version, Dell G3 computer.

What does and mean in mysql

And in mysql can combine two or more conditions in the WHERE substatement.

When using the and keyword:

  • needs to meet all conditions, and such records will be queried.

  • If any of the conditions are not met, such records will be excluded.

Example:

SELECT * FROM cs_user WHERE age >= 18 AND age <= 20
Copy after login

What does and mean in mysql

Recommended learning: mysql video tutorial

The above is the detailed content of What does and mean in mysql. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template