I have a mysql query, "SELECT * FROM task ORDER BY duedate ASC", where
"duedate" is a unix_timestamp and can be NULL. I want any NULL results
to be at the end of the list, how might I do this? Thanks.
Mark wrote:
> I have a mysql query, "SELECT * FROM task ORDER BY duedate ASC", where
> "duedate" is a unix_timestamp and can be NULL. I want any NULL results
> to be at the end of the list, how might I do this? Thanks.
Have a look at the bottom of this post:
http://groups.google.com/group/alt.php.sql/browse_thread/thr ead/ad3bc576fb0631b7/960d115e698ca173?lnk=st&q=%22AS+ISNULL% 22&rnum=3#960d115e698ca173
strawberry wrote:
> Mark wrote:
> > I have a mysql query, "SELECT * FROM task ORDER BY duedate ASC", where
> > "duedate" is a unix_timestamp and can be NULL. I want any NULL results
> > to be at the end of the list, how might I do this? Thanks.
>
> Have a look at the bottom of this post:
>
> http://groups.google.com/group/alt.php.sql/browse_thread/thr ead/ad3bc576fb0631b7/960d115e698ca173?lnk=st&q=%22AS+ISNULL% 22&rnum=3#960d115e698ca173
IF(l_name IS NULL or l_name='', 1, 0)
AS isnull
FROM students
ORDER BY isnull ASC, l_name ASC;";
what is the 1,0 for after name='' ?
Mark wrote:
> strawberry wrote:
> > Mark wrote:
> > > I have a mysql query, "SELECT * FROM task ORDER BY duedate ASC", where
> > > "duedate" is a unix_timestamp and can be NULL. I want any NULL results
> > > to be at the end of the list, how might I do this? Thanks.
> >
> > Have a look at the bottom of this post:
> >
> > http://groups.google.com/group/alt.php.sql/browse_thread/thr ead/ad3bc576fb0631b7/960d115e698ca173?lnk=st&q=%22AS+ISNULL% 22&rnum=3#960d115e698ca173
>
> IF(l_name IS NULL or l_name='', 1, 0)
> AS isnull
> FROM students
> ORDER BY isnull ASC, l_name ASC;";
>
> what is the 1,0 for after name='' ?
ah.. nvm
IF(expr1,expr2,expr3)
If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns
expr2; otherwise it returns expr3. IF() returns a numeric or string
value, depending on the context in which it is used.