- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can I avoid too many OR statements in a MySQL query?
Use MySQL IN() to avoid too many OR statements. Let us first create a table −
mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(40) ); Query OK, 0 rows affected (0.89 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(Name) values('Robert'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable(Name) values('Mike'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(Name) values('Sam'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable(Name) values('David'); Query OK, 1 row affected (0.14 sec)
Display all records from the table using select statement −
mysql> select *from DemoTable;
This will produce the following output −
+----+--------+ | Id | Name | +----+--------+ | 1 | Chris | | 2 | Robert | | 3 | Mike | | 4 | Sam | | 5 | David | +----+--------+ 5 rows in set (0.00 sec)
Following is the query to avoid too many OR statements in a MySQL query i.e. using IN() −
mysql> select *from DemoTable where Id IN(1,3,5);
This will produce the following output −
+----+-------+ | Id | Name | +----+-------+ | 1 | Chris | | 3 | Mike | | 5 | David | +----+-------+ 3 rows in set (0.00 sec)
- Related Articles
- MySQL query to select too many rows?
- How can I avoid “repair with keycache” in MySQL?
- How can I stop a running MySQL query?
- How can I stop running a MySQL query?
- How can I display MySQL query result vertically?
- Can I query how much disk space certain rows or columns are taking up in MySQL?
- Implement MySQL query using multiple OR statements. Any optimal alternative?
- How can I enable MySQL slow query log without restarting MySQL?
- MySQL query to avoid displaying duplicates values?
- How can I get maximum and minimum values in a single MySQL query?
- How can I install or enable innoDB in MySQL?
- How can I set 0 if a query returns a null value in MySQL?
- Can I get Age using BirthDate column in a MySQL query?
- Select query using MySQL IN() and avoid sorting in it
- Can we use WHERE, AND & OR in a single MySQL query?

Advertisements