$output = [];

    $query = $_GET["q"];
    if(strlen($query)<3){
        echo "[]";
        die();
    }

    $query = $wpdb->prepare($query, "");
    $words = explode(' ', $query);

    $sql =  "SELECT pm.*
            FROM wp_10_postmeta as pm JOIN
                 wp_10_posts AS p
                 ON pm.post_id = p.ID
            WHERE (meta_key LIKE 'personnel_%_last_name' OR
                    meta_key LIKE 'personnel_%_first_name' OR
                    meta_key LIKE 'personnel_%_title' OR
                    meta_key LIKE 'personnel_%_alias' OR
                    meta_key LIKE 'webpages_%_title' OR
                    meta_key LIKE 'webpages_%_alias' OR
                    meta_key LIKE 'departments_%_name' OR
                    meta_key LIKE 'departments_%_alias')
                AND p.post_status = 'publish'
            GROUP BY p.id";

    $sql_end = '';
    $i = 0;
    foreach($words as $word) {
        if($i++ == 0){
            $sql_end .= " HAVING";
        }else{
            $sql_end .= " AND";
        }
        $sql_end .= " SUM(meta_value LIKE '%{$word}%') > 0";
    }

    //. " ORDER BY meta_value ASC"
    $sql = $sql.$sql_end;
 echo $sql;
    $rows = $wpdb->get_results($sql);