Create proper MySQL query?

Question

MySQL

Good afternoon.
An amateur layout designer took on a complex project. My knowledge of MySQL is very superficial. The task is as follows: It is
necessary to extract all values ​​of the created field from all rows with catid != 16 of the jos_content table and in the wp_posts table change the post value in the post_type field to the page value in all rows in which the value of the post_date field corresponds to that found in the source table. In short, a kind of modification of the vlookup function from excel, only with the help of a MySQL query in the phpmyadmin panel. I really hope that I managed to formulate the conditions (I re-read it myself - I understood, and this is an indicator). Many thanks in advance.

Answer 1

You would have a php / mysql programmer in the team. No offense, but if _such_ level questions arise, then believe me - you will make jambs in a _complex_ project in bulk.
Basically: something like
update wp_posts set post_type='page' where post_type='post' and post_date in (select `created` from jost_content where catid<.16)