SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE `some_table` ( `id` int(11) NOT NULL, `num` int(11) NOT NULL, `user_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `some_table` (`id`, `num`, `user_id`) VALUES (1, '676', '447'), (2, '242', '666'), (3, '878', '447'), (4, '925', '447'), (5, '242', '447'); SELECT user_id FROM some_table WHERE num IN(878, 925, 242) GROUP BY user_id HAVING COUNT(*) = 3 ; SELECT some_table.user_id FROM some_table JOIN some_table st1 ON st1.user_id = some_table.user_id AND st1.num = 925 JOIN some_table st2 ON st2.user_id = some_table.user_id AND st2.num = 242 WHERE some_table.num = 878 ;