[PHP-DB] select and update together

Is it possible to select 10 records that have a NULL field and update that field to become Y instead of NULL? If so what would this syntax be? This is what I have now $result = mysql_query(SELECT * FROM catalogs WHERE PROCESSED IS NULL LIMIT $i,10); I want to add an UPdate to it, but not sure

RE: [PHP-DB] select and update together

, 2002 10:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] select and update together Is it possible to select 10 records that have a NULL field and update that field to become Y instead of NULL? If so what would this syntax be? This is what I have now $result = mysql_query(SELECT * FROM catalogs