How to write IN query in mysql?

Suppose if you want to employee names from empl table who is having emp_id is 1,4,6 or 8

Check the below code for solution

SELECT emp_name FROM empWHERE emp_id IN (1, 4, 6, 8)