Skip to content

UtilsApi sql issues with multiple queries #23

Description

@marz0405

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.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions