MySQL where column = 'x, y, z'?

You can use IN operator for this.

The syntax is as follows −

SELECT *FROM yourTableName WHERE yourColumnName
IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,...........N);

To understand the above syntax, let us create a table. The query to create a table is as follows −

mysql> create table InOperatorDemo
   -> (
   -> ClientId int
   -> );
Query OK, 0 rows affected (0.52 sec)

Insert some records in the table using insert command. The query is as follows −

mysql> insert into InOperatorDemo values(101);
Query OK, 1 row affected (0.19 sec)
mysql> insert into InOperatorDemo values(110);
Query OK, 1 row affected (0.11 sec)
mysql> insert into InOperatorDemo values(120);
Query OK, 1 row affected (0.17 sec)
mysql> insert into InOperatorDemo values(230);
Query OK, 1 row affected (0.11 sec)
mysql> insert into InOperatorDemo values(270);
Query OK, 1 row affected (0.15 sec)
mysql> insert into InOperatorDemo values(300);
Query OK, 1 row affected (0.14 sec)

Display all records from the table using select statement. The query is as follows −

mysql> select *from InOperatorDemo;

The following is The output −

+----------+
| ClientId |
+----------+
| 101      |
| 110      |
| 120      |
| 230      |
| 270      |
| 300      |
+----------+
6 rows in set (0.00 sec)

Here is the query to get value from column with IN operator −

mysql> select *from InOperatorDemo where ClientId IN('120','270','300');

The following is The output −

+----------+
| ClientId |
+----------+
| 120      |
| 270      |
| 300      |
+----------+
3 rows in set (0.00 sec)

Samual Sam

Published on 01-Apr-2019 06:42:32

• Related Questions & Answers
• What is the equivalent of Matlab's surf(x,y,z,c) in Matplotlib?
• How and why does 'z'['toUpperCase']() in JavaScript work?
• Find x, y, z that satisfy 2/n = 1/x + 1/y + 1/z in C++
• Update 'a' record with 'b' and 'b' with 'a' in a MySQL column (swap) with only 'a' and 'b' values?
• MySQL SELECT products WHERE 'average price per product' < value?
• How to make 'from' as column name in MySQL?
• MySQL query to select ENUM('M', 'F') as 'Male' or 'Female'?
• SimpleDateFormat('E, dd MMM yyyy HH:mm:ss Z') in Java
• Find maximum among x^(y^2) or y^(x^2) where x and y are given in C++
• Program to find number of string we can make where 'a' can be 'a' or 'b', and 'b' remains 'b'in Python
• Problem using the column name 'from' in a MySQL query?
• Programmer's view of Z-80
• How to get the Tkinter widget's current x and y coordinates?
• The difference between 'AND' and '&&' in MySQL?
• Converting date from 'dd/mm/yyyy' to 'yyyymmdd' in MySQL