Date: 05/31/06 (MySQL Communtiy)    Keywords: no keywords

Help with a query

array = 298,300,297,302,305,296,291,306,


UPDATE table SET billed="Yes", invoice='xxx" WHERE record [in array];


How do I update several rows at a time? (Record is the auto incrementing index number of the rows.)

Source: http://community.livejournal.com/mysql/96456.html