Searching for SP@CE 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_resultnMn4j0 ENGINE=memory select id, match (title) against ('SP@CE' in boolean mode) as score from dblp_pub_new where match (title) against ('SP@CE' in boolean mode) UNION ALL select p1.id, match (p2.title) against ('SP@CE' 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 ('SP@CE' in boolean mode) UNION ALL select id, match (source) against ('SP@CE' in boolean mode) as score from dblp_pub_new where match (source) against ('SP@CE' in boolean mode) UNION ALL select id, match (name) against ('SP@CE' in boolean mode) as score from dblp_keywords_new where match (name) against ('SP@CE' in boolean mode) UNION ALL select id, match (abstract) against ('SP@CE' in boolean mode) as score from dblp_abstracts_new where match (abstract) against ('SP@CE' in boolean mode) UNION ALL select id, match (author) against ('SP@CE' in boolean mode) as score from dblp_author_ref_new where match (author) against ('SP@CE' in boolean mode) failed syntax error, unexpected '@', expecting $end