On Thu, Mar 25, 2004 at 14:23:00 +0100, Gregor Rot <[EMAIL PROTECTED]> wrote:
Hi,
i have a table called "people" (name:varchar, lastname:varchar).
i do a select on it:
select * from people where name like '%n1%' or lastname like '%l1%'.
i would like the results in this order:
first the results that satisfy only the (name like '%n1%') condition, then the ones that satisfy only the (lastname like '%l1%') condition and last the results that satisfy both conditions.
Is this possible in only one SQL? (note that the search conditions n1 and l1 differ from search to search.
Yes. You can order by true/false results from conditions to get the results in the desired order.
Thank you - sorry, but how do you do that?
Tnx, Gregor
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
