the starting point is the article ID , which is assumed to be 123
. Now I want to find a match post_id = 123 , and then match meta_key = _ thumbnail_id and meta_value = 456
and then use the ID of 456 to find the ID, of wp_posts data table.

data sheet wp_postmeta

post_id / meta_key / meta_value
123 / _thumbnail_id / 456

data sheet wp_posts (the value I want)

ID / guid
456 / guid

data sheet wp_posts (go back to replace the article)

ID / guid
123 / guid

it"s a bit awkward, but I really don"t know how to update the table
what I want to update is the same data table, the same bit, but a different ID
the whole thing is dead.

I want to update the same table, the same bit, but a different ID
the whole thing is dead.

I wrote something like this

UPDATE wp_posts
SET posts.guid = posts.guid 
FROM wp_posts posts
INNER JOIN wp_postmeta meta
ON meta.meta_key = "_thumbnail_id"
WHERE meta.post_id = posts.ID

report:

-sharp1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "FROM wp_posts posts
INNER JOIN wp_postmeta meta 
ON meta.meta_key = "_thumbnai" at line 3

PS I didn"t write this database. I want to send the data to me. I need to check and organize the data first