[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