Cara Menggunakan Operator IN Di MySQL

Pada tutorial kali ini, kita akan belajar tentang Cara Menggunakan Operator IN Di MySQL. Penggunaan Operator IN sama dengan penggunaan operator OR, hanya saja operator IN digunakan untuk mereduksi penggunaan operator OR pada Select, Insert, Update, maupun Delete statement.

Sintak Dasar

Di bawah ini adalah sintak dasar operator IN di MySQL:

Select Statement

SELECT * FROM table_name
WHERE column_name IN (value1, value2, value3, ..., valueN);

Update Statement

UPDATE table_name
SET column_name = value
WHERE column_name IN (value1, value2, value3, ..., valueN);

Delete Statement

DELETE FROM table_name
WHERE column_name IN (value1, value2, value3, ..., valueN);

Contoh

Asumsikan Anda telah memiliki sebuah table "tbl_pegawai" dengan data-data berikut:

mysql> SELECT * FROM tbl_pegawai;
+------------+------------------+---------------+----------+------------+------------+
| id_pegawai | nama_pegawai     | jenis_kelamin | gaji     | alamat     | departemen |
+------------+------------------+---------------+----------+------------+------------+
|          1 | Nursalim         | L             |  1000000 | Brebes     | IT         |
|          2 | Naura Krasiva    | P             |  1500000 | Tegal      | FIN        |
|          3 | Nurul Anawariyah | P             |  2000000 | Pemalang   | HRD        |
|          4 | Achmad Fathoni   | L             |  3000000 | Batang     | IT         |
|          5 | Nurul Hikmah     | P             |  9000000 | Pekalongan | DIR        |
|          6 | Iskiyati         | P             |  3000000 | Semarang   | ACC        |
|          7 | Dodi Al Farizi   | L             |  3000000 | Kendal     | FIN        |
|          8 | Susanto          | L             |  4500000 | Cilacap    | MKT        |
|          9 | Susanti          | P             | 43500000 | Banyumas   | MKT        |
|         10 | Doni Nugroho     | L             |  3750000 | Pemalang   | HRD        |
+------------+------------------+---------------+----------+------------+------------+
10 rows in set (0.00 sec)

Dari data "tbl_pegawai" diatas,

• Tampilkan semua data dari "tbl_pegawai" yang berada di departement IT, ACC, dan FIN menggunakan operator OR
  
  

  mysql> SELECT * FROM tbl_pegawai
      -> WHERE departemen = 'IT'
      -> OR departemen = 'ACC'
      -> OR departemen = 'FIN';
  +------------+----------------+---------------+---------+----------+------------+
  | id_pegawai | nama_pegawai   | jenis_kelamin | gaji    | alamat   | departemen |
  +------------+----------------+---------------+---------+----------+------------+
  |          1 | Nursalim       | L             | 1000000 | Brebes   | IT         |
  |          2 | Naura Krasiva  | P             | 1500000 | Tegal    | FIN        |
  |          4 | Achmad Fathoni | L             | 3000000 | Batang   | IT         |
  |          6 | Iskiyati       | P             | 3000000 | Semarang | ACC        |
  |          7 | Dodi Al Farizi | L             | 3000000 | Kendal   | FIN        |
  +------------+----------------+---------------+---------+----------+------------+
  5 rows in set (0.05 sec)
  
  

• Tampilkan semua data dari "tbl_pegawai" yang berada di departemen IT, ACC, dan FIN menggunakan operator IN
  
  

  mysql> SELECT * FROM tbl_pegawai
      -> WHERE departemen IN ('IT','ACC','FIN');
  +------------+----------------+---------------+---------+----------+------------+
  | id_pegawai | nama_pegawai   | jenis_kelamin | gaji    | alamat   | departemen |
  +------------+----------------+---------------+---------+----------+------------+
  |          1 | Nursalim       | L             | 1000000 | Brebes   | IT         |
  |          2 | Naura Krasiva  | P             | 1500000 | Tegal    | FIN        |
  |          4 | Achmad Fathoni | L             | 3000000 | Batang   | IT         |
  |          6 | Iskiyati       | P             | 3000000 | Semarang | ACC        |
  |          7 | Dodi Al Farizi | L             | 3000000 | Kendal   | FIN        |
  +------------+----------------+---------------+---------+----------+------------+
  5 rows in set (0.00 sec)
  
  

Sekian tutorial singkat tentang Cara Menggunakan Operator IN Di MySQL. Semoga bermanfaat & Happy Learning MySQL.

Salam,

Nursalim