MYSQL: want to update 1 records out of 10 records.

[shelbytll]

Hi,
if I have 10 records with PartID ="monitor" in the database but I just want to update 1 record with PartID ="monitor", is there a better way to do it? The table has an auto_increment field named ID .

Currently, I'm doing it this way:
$rs = $cn->Execute("select ID from table1 where PartID='monitor'");
ID = $rs->fields[0];
$cn->Execute("Update table1 set DateIn='$mydate' where ID=$ID");

I was wondering is there a faster and better way?
Sometime, I may update 5 records out of those 10, or even 9. Or even 100 out of 500.

[LordShryku]

UPDATE table1
SET DateIn='$mydate'
WHERE PartID='monitor'
LIMIT 1

[shelbytll]

Hi,
thanks.
Does the "LIMIT 1" applies to MSSQL also?
I would like to make it DB independent.

[LordShryku]

Dunno....I've been lucky enough to stay away from MSSQL. It does NOT work on Oracle, so database independance is a long shot.