How to use WHERE IN as a data filter?

Question

SQL

Where in adds results, but you need to filter:

SELECT DISTINCT v.id, v.*, v.english_level
FROM vacancies v
         LEFT JOIN specializations s ON s.id = v.specialization_id
LIMIT 30

Answer 1

WHERE v.id IN (1,2,3,4)