MySQL
keyboard_arrow_down 295 guides
chevron_leftOperators
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
MySQL | AND
schedule Mar 5, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Check out the interactive map of data science
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?
thumb_up
thumb_down
Comment
Citation
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!
