hi.
select Title, IF(Title LIKE "%TOMMY%", 1, 0) as check
from inv where...
... order by check desc;
hth.
-ravi.
-----Original Message-----
From: Carl Schrader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 10:30 AM
To: [EMAIL PROTECTED]
Subject: Query Question
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering the first results from the second in a script. I would like to
do this with a single query. Can that be done?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php