January 24th, 2013, 10:54 PM
Join Date: Jan 2013
Time spent in forums: 1 h 5 m 8 sec
Reputation Power: 0
Finding items from one table that don't exist in another table
OK, I hope I will explain this clearly,
I have three tables:
wp_posts stores information about the post.
wp_postmeta stores information like custom fields of the post.
companies is a table that gets updated daily with current companies, so if a company is no more our client then they will get deleted from the companies table.
Now, wp_posts and wp_postmeta share post_id and wp_postmeta and companies share company_id, however, wp_postmeta stores company_id as a char while companies stores company_id as an int.
I would like to find all the company_id that exist in wp_postmeta but don't exist in companies and then change their post_status in wp_posts from publish to draft.
I hope that's clear,