EVOLUTION-MANAGER

Edit File: function_query_expand_multiple.result

SET NAMES UTF8; DROP TABLE IF EXISTS synonyms; CREATE TABLE synonyms ( term varchar(255), synonym varchar(255), INDEX (term) ); INSERT INTO synonyms VALUES ('Rroonga', 'Rroonga'); INSERT INTO synonyms VALUES ('Rroonga', 'Groonga Ruby'); INSERT INTO synonyms VALUES ('Mroonga', 'Mroonga'); INSERT INTO synonyms VALUES ('Mroonga', 'Groonga MySQL'); SELECT mroonga_query_expand('synonyms', 'term', 'synonym', 'Mroonga Rroonga PGroonga') AS query; query ((Mroonga) OR (Groonga MySQL)) ((Rroonga) OR (Groonga Ruby)) PGroonga DROP TABLE synonyms;