Twitter 
Facebook
chevron_left
Operators
0
0
0
new
MySQL | AND
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightOperators
schedule Mar 10, 2022
Last updated MySQL
Tags tocTable of Contents
expand_more MySQL's AND operator can be used in conjunction with a WHERE clause to return values that satisfy all the conditions separated by AND in the WHERE clause.
Syntax
SELECT column_name(s)FROM table_nameWHERE condition1 AND condition2;
Examples
Consider the following table about some students:
student_id | fname | lname | day_enrolled | age | username |
|---|---|---|---|---|---|
1 | Sky | Towner | 2015-12-03 | 17 | stowner1 |
2 | Ben | Davis | 2016-04-20 | 19 | bdavis2 |
3 | Travis | Apple | 2018-08-14 | 18 | tapple3 |
4 | Arthur | David | 2016-04-01 | 16 | adavid4 |
5 | Benjamin | Town | 2014-01-01 | 17 | btown5 |
The above sample table can be created using the code here.
Basic usage
To return students who are older than 17 and enrolled after 2017-01-01:
SELECT * FROM studentsWHERE age > 17 AND day_enrolled > '2017-01-01';
+------------+--------+-------+--------------+------+----------+| student_id | fname | lname | day_enrolled | age | username |+------------+--------+-------+--------------+------+----------+| 3 | Travis | Apple | 2018-08-14 | 18 | tapple3 |+------------+--------+-------+--------------+------+----------+
We can see that Travis is the only student to meet both conditions.
NOTE
There is no limit to how many conditions we can apply (i.e. we can use many AND).
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and
