Searching for seti@home with no syntactic query expansion (no support for multi-word queries for performance reasons) in all metadata.Query 3 create temporary table if not exists query_resultC2QcFk ENGINE=memory select id, match (title) against ('seti@home' in boolean mode) as score from dblp_pub_new where match (title) against ('seti@home' in boolean mode) UNION ALL select p1.id, match (p2.title) against ('seti@home' in boolean mode) as score from dblp_pub_new p1 join dblp_pub_new p2 on p1.crossref=p2.dblp_key where match (p2.title) against ('seti@home' in boolean mode) UNION ALL select id, match (source) against ('seti@home' in boolean mode) as score from dblp_pub_new where match (source) against ('seti@home' in boolean mode) UNION ALL select id, match (name) against ('seti@home' in boolean mode) as score from dblp_keywords_new where match (name) against ('seti@home' in boolean mode) UNION ALL select id, match (abstract) against ('seti@home' in boolean mode) as score from dblp_abstracts_new where match (abstract) against ('seti@home' in boolean mode) UNION ALL select id, match (author) against ('seti@home' in boolean mode) as score from dblp_author_ref_new where match (author) against ('seti@home' in boolean mode) failed syntax error, unexpected '@', expecting $end