Bruno Wolff III wrote:
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%'
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 satis
