SQL query for NULL value

SELECT * FROM cand_table WHERE cand_resume = 'NULL';

Using phpMyAdmin, I can see that I have a dozen or so rows where the "cand_resume" column field contains the value NULL.

I'm trying to do an UPDATE to insert a "fake" value for testing purposes, but my query is pulling up 0 rows.

So I tried a SELECT...to see if I can even access these rows. But still, no dice -- just getting the 0 rows.

What am I doing wrong?

You just need to use the proper sql syntax. Columns can be compared to IS NULL or IS NOT NULL.

SELECT * FROM cand_table WHERE cand_resume IS NULL;

Affected rows: 35

UPDATE cand_table SET cand_resume = 'http://www.xxxxx.com/xxxxx/resumebin/readme.txt' WHERE cand_resume IS NULL

thanks YD

First time i did a query against NULL.

(scribbling a note to self in mysql book)