Re: Re: ORDER BY question
| From: | DL Neil | Date: | Thu, 28 Feb 2002 23:27:43 +0000 |
| Subject: | Re: Re: ORDER BY question | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17374@lists.php.net to get a copy of this message | ||
Hi Chris,
Did you get a useable answer to this?
> Using PHP and MySQL, how can I do an ORDER BY where city = $city?
What
> happens is this, I have a search engine which works nicely, but I want
to
> bring up the closest matches to the search first at the top, how can I
do
> this?
>
> Say you enter Munich Hotels, I want all entries with Munich Hotels to
appear
> first before the rest, any ideas?
Try:
SELECT ...
ORDER BY city="Munich Hotels", city;
The first 'column' in the ORDER BY clause evaluates to TRUE or FALSE,
and thus puts Munich Hotels (TRUE) above everything else (FALSE), and
within those two groupings city is sequenced into alpha ASC (meaningless
for the M-Hotels grouping because they all have the same city value).
Ok?
=dn