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