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 git.master, git.master_jit, rfc.property-hooks
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

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

preferences:
30.14 ms | 406 KiB | 5 Q