When I run this query I get the results as expected.
SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500; show meta;
But when I run this
SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1; show meta;
I get an error saying "Invalid options in query string, make sure they are separated by commas"
If I remove the show meta part and run the query it works but obviously I don't get the meta information.
SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1;
Can anyone please tell me how to run a query with options and also meta information.
When I run this query I get the results as expected.
SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500; show meta;But when I run this
SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1; show meta;I get an error saying "Invalid options in query string, make sure they are separated by commas"
If I remove the
show metapart and run the query it works but obviously I don't get the meta information.SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1;Can anyone please tell me how to run a query with options and also meta information.