sql - Get all general data, and retrieves privacy data (applies if the column that has the value matches the desired parameter) In MySQL

Question

ID	NPK	Satker	Privasi
1	211017	111111	Rahasia
2	211017	111111	Umum
3	216038	555555	Rahasia
4	218024	333333	Umum
5	204031	666666	Rahasia
6	204031	666666	Umum

question from:https://stackoverflow.com/questions/65950940/get-all-general-data-and-retrieves-privacy-data-applies-if-the-column-that-has

Answer 1

You can use OR in the WHERE clause as follows:

SELECT * FROM table 
 WHERE Satker IN ('111111', '666666')
   and (Privasi = 'Umum' or npk = 211017)