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