how do I update fields with a select for the where clause?

Question

I have tables, 1 called "articles" and another called "links".

I want to take the url and title from the table links and update the articles table with the data from the links table. I am unsure how to do this. The links table has article_id referenced to it, can anyone help?

Here is some pseudo-code if this helps?

UPDATE articles 
   SET articles.url, 
       articles.title = (SELECT links.url, 
                                links.title 
                           FROM links 
                          WHERE articles.id = links.article_id)

Does this make sense?

Answer 1

UPDATE articles, links
SET articles.url = links.url,  
articles.title = links.title
WHERE articles.id = links.article_id

OR

UPDATE articles
INNER JOIN links ON (articles.id = links.article_id)
SET articles.url = links.url,  
articles.title = links.title