Skip to content

UtilsApi sql issues with multiple queries #23

@marz0405

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

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions