Try
SELECT * FROM table ORDER BY col LIMIT 23 ;
If the col type is numeric, trying to match the string NULL might be the
problem. And, if it is numeric, the NULL values will be listed first in
'ORDER BY col'.
This doesn't really solve the problem of not being able to select 'where
col is
It might help if you say what version of MySQL you're using, give the
table schema, etc. I couldn't reproduce the behavior you describe
here.
--Pete
On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote:
Hi,
I have a table with a column that has the Unique key constraint
You need a LEFT JOIN.
SELECT blah, blah, blah
FROM bite bite LEFT JOIN person agency ON agency.person_id =
bite.bite_agency_id
WHERE bite.bite_id = AC-2003-0004;
Check out http://www.mysql.com/doc/en/JOIN.html to learn more about LEFT
JOIN.
Regards,
Mike Hillyer
www.vbmysql.com
-Original