Re: [SQL] order of results

2004-04-06 Thread Bruno Wolff III
On Sat, Apr 03, 2004 at 17:08:34 +0200, Gregor Rot <[EMAIL PROTECTED]> wrote: > 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

Re: [SQL] order of results

2004-04-05 Thread Gregor Rot
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%'. i would like the results in this

Re: [SQL] order of results

2004-03-26 Thread Bruno Wolff III
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

[SQL] order of results

2004-03-26 Thread Gregor Rot
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