[thelist] mysql - null - returns results anyway

[Phil Turmel]

On 12/22/2009 10:53 PM, 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)
> 

Hmmm.  Learn something new every day.  I'm now going to have to play
with query analyzers on the platforms I have at hand to see if the
optimization I thought mattered was a figment of my imagination.

Thanks for the tip.  Can you tell I'm an EE, not a CS grad?

Phil