MySql help #1
| From: | elias | Date: | Thu, 02 Aug 2001 08:30:07 +0000 |
| Subject: | MySql help #1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-60862@lists.php.net to get a copy of this message | ||
How can I update only N fields from the database?
usually we do:
UPDATE table1 SET field='VALUE' WHERE condition1
now I want to update fields with a certain condition but only X fields out N
total fields.
ie:
id value
--- -------
1 a
2 b
3 c
4 d
5 e
how can i update such like:
UPDATE table1 SET {only 2 records} value='aa'
so I have any two fields now have the 'aa' value