Subject: sql statement - complex order by
| From: | Neil Smith [MVP, Digital media] | Date: | Wed, 04 Jul 2007 22:28:20 +0000 |
| Subject: | Subject: sql statement - complex order by | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43745@lists.php.net to get a copy of this message | ||
At 20:36 02/07/2007, you wrote:
Message-ID: <F4.81.24153.5C359864@pb1.pair.com> To: php-db@lists.php.net Date: Mon, 02 Jul 2007 14:34:35 -0500 From: Bryan <bcotter@wordsearchbible.com> SELECT * FROM productgroup WHERE groupid = $productid AND label = 'Cats' ORDER BY title SELECT * FROM productgroup WHERE groupid = $productid AND label != 'Cats' ORDER BY label,title I'd like to find a way to combine these 2 statements. I want to list out all the products, ordered by title but listing out all the Cats products first. Any way to do that without having separate statements?See http://dev.mysql.com/doc/refman/5.0/en/union.html (SELECT * FROM productgroup WHERE groupid = $productid AND label = 'Cats' ORDER BY title) UNION (SELECT * FROM productgroup WHERE groupid = $productid AND label != 'Cats' ORDER BY label,title) HTH Cheers - Neil