Skip to content

[mysql] like does not escape apostrophe #30

@Flamenco

Description

@Flamenco

The apostrophe is not escaped in this case:

let titleQuery = "it's"
qb.like('s.title', titleQuery, 'both')

The produced SQL has invalid syntax

AND `s`.`title` LIKE '%it's%'

The documentation states:

All fields are escaped automatically, no exceptions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions