I want to update multiple fields chronologically by the "id" field.
Something like this in theory (but my syntax is off)
Code: Select all
UPDATE `table` SET `field` = 'blah' WHERE `id` = '1-7';"Moderator: General Moderators
Code: Select all
UPDATE `table` SET `field` = 'blah' WHERE `id` = '1-7';"Code: Select all
UPDATE `table` SET `field1` = 'blah', `field2` = 'blah', `field3` = 'blah' WHERE `id` = '1-7'thanks for the response. sorry, let me better clarify... I want to update field 'category1' to equal '2a' for id '1-7'. this is what i have, but only alters where id=1Pimptastic wrote:Code: Select all
UPDATE `table` SET `field1` = 'blah', `field2` = 'blah', `field3` = 'blah' WHERE `id` = '1-7'
Code: Select all
UPDATE `listings` SET `category1` = '2a' WHERE `id` = '32-51';Code: Select all
UPDATE `listings` SET `category1` = '2a' WHERE `id` => 1 AND `id` <= 7Code: Select all
UPDATE `listings` SET `category1` = '2a' WHERE `id` BETWEEN 1 AND 7Code: Select all
UPDATE `listings` SET `category1` = '2a' WHERE `id` IN(1, 2 ,3, 4, 5, 6, 7)