How to select the id of a record from a table where two keys match?

Question

MySQL

SELECT entity_id FROM products WHERE value_id = '19' and value_id = '12'

There is an entity_id in the products table whose value_id is 19 and 12. How to choose this id?
Or such a request

SELECT entity_id FROM products WHERE value_id = '19' and (value_id = '2' OR value_id = '12')

Answer 1

SELECT `p1`.`entity_id` 
    FROM `products` AS `p1`
    JOIN `products` AS `p2` USING(`entity_id`)
    WHERE `p1`.`value_id` = '19' 
        AND `p2`.`value_id` = '12'

Answer 2

SELECT entity_id FROM products WHERE value_id IN (19, 12);