make many update queries in one query

[Mgccl]

is that possible?
how could you connect those UPDATE queries?
when I use a ;
it tells me I got syntax error.

[Piranha]

Unfortunatley (or maybe it's good) ; does not work when doing a SQL query from PHP. There are other ways to insert in tables as long as the inserts is in the same table:

INSERT INTO test (column1, column2) 
VALUES ('row1_col1', 'row1_col2'), 
('row2_col1', 'row2_col2')

But to update is not possible unless you want it to update to the same result:

UPDATE test 
SET column1 = 'updated', column3 = column3 + 2 
WHERE column2 = 'brothers';

If you want to update with different values you have to use many queries.