Re: show required row first and then other remaining rows
| From: | Andrew Ballard | Date: | Thu, 25 Oct 2007 18:57:21 +0000 |
| Subject: | Re: show required row first and then other remaining rows | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-263672@lists.php.net to get a copy of this message | ||
This should work:
ORDER BY CASE WHEN id = 3 THEN 0 ELSE 1 END, name
Andrew