Using Subqueries with the IN Operator in MySQL

Q

How To Use Subqueries with the IN Operator in MySQL?

✍: FYIcenter.com

A

A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to use a subquery with the IN operator. It returns all links with ids in the fyi_rates table.

mysql> SELECT id, url, tag, YEAR(created) As year 
   FROM fyi_links WHERE id IN (SELECT id FROM fyi_rates);
+-----+-------------------+------+------+
| id  | url               | tag  | year |
+-----+-------------------+------+------+
| 101 | dev.fyicenter.com | DEV  | 2006 |
| 102 | dba.fyicenter.com | DBA  | 2006 |
| 103 | sqa.fyicenter.com | SQA  | 2006 |
+-----+-------------------+------+------+
3 rows in set (0.06 sec)

⇒ Using Subqueries with the EXISTS Operator in MySQL

⇐ What Is a Subquery in MySQL

⇑ SELECT Statements with JOIN and Subqueries in MySQL

⇑⇑ MySQL Database Tutorials

2017-09-17, 2176🔥, 0💬