If the search word includes %...

[kmvan]

const { format, escape } = require('sqlstring')
const searchWord = 'word%' // Only want to search end of like "abcword%".
const sql = format(
  `
SELECT * FROM ?? WHERE ?? LIKE ?
`,
  ['table', 'content', `%${escape(searchWord)}`]
)
console.log(sql)
// SELECT * FROM `table` WHERE `content` LIKE '%\'word%\''

Expected output

// SELECT * FROM tableWHEREcontentLIKE '%word\%'

Actual output

// SELECT * FROM tableWHEREcontentLIKE '%\'word%\''

Any idea?

[dougwilson]

Escape function only escapes a value into a sql value. You need to escape the various characters used in LIKE if you don't want them to be special just like with REGEXP.

[kmvan]

If the search word includes ? question mark...

[dougwilson]

I'm not sure what your comment means. The LIKE statement does not assign any special meaning to a question mark, only percent signs and underscores.