[thelist] mysql - null - returns results anyway
Bob Meetin
bobm at dottedi.biz
Tue Dec 22 22:01:26 CST 2009
r937 wrote:
>> ... I often find myself using these sorts of quick-and-dirty queries
>> as the basis for views, in which case the extra
>> "order by" is useful and appropriate.
>
> ORDER BY is ~never~ appropriate for a view
>
> full stop
>
>
> ;o)
>
by view I mean I have a list of 50 or so results and I sort them by
product name or business name or whatever (order by product name asc).
is there a different, better method? this particular db will probably
have 100, certainly not 200 or so product by various vendors and categories.
-- Bob
More information about the thelist
mailing list