Online PHP editor | refs for 8cHFC

<?php $q = '8gb pro'; $parts = explode(' ', $q); $sort = "ORDER BY\n"; $sort .= " (CASE WHEN `titel` REGEXP '[[:<:]]{$q}[[:>:]]' THEN 1 ELSE 2 END),\n"; $sort .= " (CASE WHEN `titel` REGEXP '[[:<:]]" . implode("[[:>:]]' AND `titel` LIKE '[[:<:]]", $parts) . "[[:>:]]' THEN 1 ELSE 2 END),\n"; $sort .= " (CASE WHEN `beschreibung` REGEXP '[[:<:]]" . implode("[[:>:]]' AND `beschreibung` LIKE '[[:<:]]", $parts) . "[[:>:]]' THEN 1 ELSE 2 END),\n"; $sort .= " `views` DESC"; echo $sort;