php - Multiple MySQL Queries in ONE While Ignoring Duplicate Matched IDs -
i asked question combine multiple mysql queries on same table one , received noteworthy answer @paul griffin . as stated in other question linked above, have multiple queries combined 1 query. these queries consist of exact matching , broad matching search terms. i searching through posts on wordpress website. keep things simple, i'm looking through following columns in posts table: post_title (article title), post_name (article url slug), , post_excerpt (article summary). just keep things simpler sake of question, let's have search term of "floor finish", , i'm searching through column post_title . as stated earlier, i'm looking exact matches , broad matches. so 3 searches placed: floor finish floor finish that produce query like: ( select `id`, `post_title` `tps_3_posts` `post_status` = 'publish' , `post_title` '%floor finish%' ) union ( select `id`, `post_title` `tps_3_posts` `post_status` = 'publish...