Skip to content

Impossible to use the '%' character in a db query (MySQL) #369

Open
@albertoakg

Description

Description

It's not possible to use the % character in a query using MySQL driver.
My query is a matter like that: SELECT filed1, filed2, filed3 FROM table1 WHERE field2 LIKE '%abcdef%'
But in this form, it doesn't work. Instead, it works well if I don't use the LIKE with %.
I already tried to escape this character with \ and with ", but it continues to not work.

Expected Behavior

I expect that the query works with %

Metadata

Assignees

No one assigned

    Labels

    triage/pendingIssue or PR is pending for triage and prioritization.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions