Pseudo code for the SQL query: ' UPDATE myTable SET posX[id] = @arrayX[id], posY[id] = @arrayY[id] ' @arrayX, arrayY being arrays which store new values for the posX and posY field. Updating multiple rows with one query'. Updating multiple columns and multiple rows with one. Which makes it so much easier to update SQL and PHP. A positioned update using a WHERE CURRENT OF clause updates the single row at the current position of the cursor. This can be more accurate than a searched update that uses a WHERE clause to qualify the rows to be updated. A searched update modifies multiple rows when the search condition does not uniquely identify a single row. SQL - Update multiple records in one query. Multiple records in one query. Telefon Ucun Oyun Yukle Pulsuz Video here. I try like that: UPDATE config SET t1. Multiple rows in a single SQL query?

Could you post some schema info so we can be little clearer on what you want? You can certainly do: Update TableA Set columnA = 1 Where ColumnB In (Select ColumnA From TableB) Or ColumnC In (Select ColumnA From TableC) If that is what you are asking. BTW-ColumnC could just as easily be another criteria on ColumnB. Jack Corbett Consultant Dont let the good be the enemy of the best. -- At best you can say that one job may be more secure than another, but total job security is an illusion.