Searching for TNF- with no syntactic query expansion in all metadata.Query 3 create temporary table if not exists query_resultuYkyNh ENGINE=memory select id, match (title) against ('TNF-' in boolean mode) as score from dblp_pub_new where match (title) against ('TNF-' in boolean mode) UNION ALL select p1.id, match (p2.title) against ('TNF-' 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 ('TNF-' in boolean mode) UNION ALL select id, match (source) against ('TNF-' in boolean mode) as score from dblp_pub_new where match (source) against ('TNF-' in boolean mode) UNION ALL select id, 1 from dblp_pub_new where source = 'TNF-' UNION ALL select id, match (name) against ('TNF-' in boolean mode) as score from dblp_keywords_new where match (name) against ('TNF-' in boolean mode) UNION ALL select id, 1 from dblp_keywords_new where name = 'TNF-' UNION ALL select id, match (abstract) against ('TNF-' in boolean mode) as score from dblp_abstracts_new where match (abstract) against ('TNF-' in boolean mode) UNION ALL select id, match (author) against ('TNF-' in boolean mode) as score from dblp_author_ref_new where match (author) against ('TNF-' in boolean mode) failed syntax error, unexpected $end