3v4l.org

run code in 300+ PHP versions simultaneously
<?php $categories = array('Colour', 'Portrait'); $sql = "SELECT p.*\nFROM (\n SELECT '"; $sql .= implode("' AS keyword\n UNION ALL\n SELECT '", $categories); $sql .= "' AS keyWord\n) k\nJOIN photos p ON CONCAT(',', p.keyWords, ',') LIKE CONCAT('%,', k.keyWord, ',%')\n"; $sql .= "GROUP BY p.id\nHAVING COUNT(*) = " . count($categories); echo $sql;
Output for 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.27, 8.4.1 - 8.4.14
SELECT p.* FROM ( SELECT 'Colour' AS keyword UNION ALL SELECT 'Portrait' AS keyWord ) k JOIN photos p ON CONCAT(',', p.keyWords, ',') LIKE CONCAT('%,', k.keyWord, ',%') GROUP BY p.id HAVING COUNT(*) = 2
preferences:
157.75 ms | 407 KiB | 5 Q