Mark Hensler — Mon, 28 Jul 2003 18:56:46 +0000

If each record must have seperate values, then you'll have to run a seperate update query for each record. I've not found a way around that for MySQL 3.

MySQL 4, on the other hand, may have other options. I've heard of multi-table updates (similar to select queries with join statements), but I've not read much about them. I don't know if you could update multiple records within one table, but the capability may have been added as well.

nuk3 — Mon, 28 Jul 2003 08:16:27 +0000

Each field will have a different value. So what can I do?

Mark Hensler — Mon, 28 Jul 2003 06:42:32 +0000

You can only update 2 or more records if you want the fields to be the same. (So you can't update one records with field_one=1 and record two with field_one=2)

Is this the case? If so, just edit the WHERE statement to include some identification for all desired records.