MySQL: ERROR 1054 (42S22): Unknown column in 'where clause'

Answer 1

ebdurls.* has no value. That is what is causing your error. The database has no idea what you are trying to do.

You probably need to use a subquery or add this logic into your application.

Or something like:

UPDATE wp_posts, ebdurls ...

Answer 2

You haven't specified what ebdurls is, add a from statement to your query:

UPDATE 
    wp_posts, ebdurls
SET 
    wp_posts.guid = ebdurls.url 
WHERE 
    wp_posts.id=ebdurls.ebdid;

edit: Bill was right, have fixed the format now. Oops.

Answer 3

That was exactly the mistake. The query was OK and has been executed! Thank you so much!!