Home / server / Questions / 210436
Accepted
Metalshark
Asked: 2010-12-09 06:28:58 +0800 CST

Escaping a question mark on the MySQL CLI

  • 772

How do you escape a question mark character in a string on the MySQL CLI?

There are many methods to avoid having to escape characters, but from an ease-of-use perspective I would quite like to do some SELECT statements containing LIKE queries, some of which contain question marks and the usual \? does not work.

mysql command-line-interface

1 Answers

  1. Best Answer

    LIKE doesn't use ?. LIKE uses % and _.

    • 0