Twitter 
Facebook
chevron_left
Operators
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
MySQL | AND
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightOperators
schedule Jul 1, 2022
Last updated local_offer 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).
Join our newsletter for updates on new DS/ML comprehensive guides (spam-free)
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
