How do you properly Update more then one SQL row at a time? Like would I go

Update table set row="w.e" where key="w.e" AND set row2="w.e" where key="w.e"

I assume also that its better to update everything in one line so that you are executive fewer queries.

Thanks

I'm a bit puzzled here, because what you seems to look for is exactly what the update statement does.
Sql is a set oriented language, meaning that your actions are applied to a set of rows.

When you do an update, you say what column should be updated to which vale, and then you filter the rows you want with a "where" clause.

Given your question, I assume that our table is

row  |  row2  | key
-----+--------+----
w.a  + w.b    + w.e
-----+--------+----
w.c  + w.d    + w.e

Though It's a bit strange to me...
Don't forget that a row is composed by an series of columns.
So, naming your columns row1, row2 and such is mostly disorienting.

Now, about your example, you would write it:

update table
set row='w.e', row2='w.e'
where key='w.e'

To update the column "row1" and "row2" of every rows (lines) whose key column value is "w.e"

Ya I was just asking how to set more than one thing at once, I guess my description was pretty bad but your answer was great. Thanks!

Update Table Set Target_Column_N = Target_Value_N Where Condition_Is_Met

You can adjust the where criteria to decide which rows will be updated. You could say WHERE ID = 1 and only get 1 row, or you could say WHERE ID IN (1, 2) and get 2 rows. Or you can say WHERE CREATED_DATE BETWEEN '1/1/08' AND '12/31/08' and get a whole bunch of rows.

Then you adjust the SET X = Y part to decide what values get applied to all those rows you're changing.