select inside update query?

[Anon]

is it possible to run a update a query using data from a select query ?? i know it is possible in SQL any ideas in MySQL ??

ie

UPDATE table_1 SET table1.linkID = '
SELECT table_2.ID FROM table_2 WHERE table_2.ID = table_1.ID
'

any ideas guys ??

[mikesgt2]

You can't. I think they will be bringing that in MySql 4 -- see the todo section of the documentation.

If you are using it in a php script just run the queries separatly storing the result of the first in a variable and usinmg that variable to update the database.