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...