SELECT and UPDATE work the same way?

[Elliott]

I was wondering....if i wanted to update the same rows of a table as i got from a query like the one below. Would it be possible to use the GROUP BY and ORDER by etc with the UPDATE statement, so i update those rows only?

<?PHP
$query3 = "SELECT time, row_number, seat, booked FROM rollercoaster 
               GROUP BY time, row_number, booked 
               HAVING (((time)='".$time."') AND ((booked)=0)) 
               ORDER BY time, row_number 
               LIMIT $seat"; 
?>

[Kudose]

SELECT what FROM table(s) WHERE restrictions GROUP BY what ORDER BY what ASC|DESC LIMIT skip, max

UPDATE table(s) SET what WHERE restrictions ORDER BY what LIMIT skip, max

That about does it...

http://dev.mysql.com/doc/mysql/en/UPDATE.html

[Elliott]

thanks for info.

Was wondering if it would insert it in exactly the same way, but ive thought of a better way to do it.

perform the SELECT, then loop the rows, with the UPDATE within the loop 🙂

Elliott