sort mysql query by filtered query
- by kalpaitch
I have two mysql queries:
$sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc";
and
$sql = "SELECT * FROM content ORDER BY lastUpdated desc";
The end result is to have all rows returned from a particular table 'content' but have those that match the variable $filter at the top. Is there either a single query that could combine these two or should I be using a JOIN?