Not Empty MySql

Anon

I am looking for the mysql command to display only records that have a value in a specific column. I think it is some kind of list command but I can not find it in the manual.

Please help

Anon

I forgot to put the code I am trying:

include ("config.inc.php");

$sql = "select * from visit WHERE log_in<>'0'";
$namo = mysql_query($sql);
$r = mysql_fetch_array($namo);

do{
printf("<center>%s %s - %s - %s</center>\n", $r["first_name"], $r["last_name"], $r["custid"], $r["log_in"]);

} while ($r = mysql_fetch_array($namo));

This returns all records, not just the records with a value in "log_in"

[deleted]

Your query checks for records where the log_in is not equal to a string containing a zero. Is your column a string type or an integer?

Just for the record, zero is also a value. If you truely have no value in the column, it will contain NULL, and you'd select them like this:

SELECT *
FROM table
WHERE field IS NOT NULL;

One more note just to clarify: NULL is not the same as zero and not the same as an empty string.

Anon

This did not work:

$sql = "select * from visit WHERE log_in<>'0'";

This does:

$sql = "select * from visit WHERE log_in<>''";

I am looking for an empty string . . .

Anon

Sorry, I am looking for a not empty string and I have found the solution.

Thank You Vincent.