I believe that according to the SQL standard you have to provide one explicitly. And therefore you get to choose your own. Most people use back-slash.
Thus: > Select * from INFORMATION_SCHEMA.`TABLES` where TABLE_NAME LIKE 'bit#_table' > ESCAPE '#' will find only tables with underscores. The same character can escape both '%' and '_'. I don't know whether Drill does this, but Calcite does. Julian On Oct 14, 2014, at 7:41 PM, Norris Lee <[email protected]> wrote: > Hi, > > Does anyone know what the escape character is for the LIKE clause? > Eg. Select * from INFORMATION_SCHEMA.`TABLES` where TABLE_NAME LIKE > 'bit_table'; > I want to look for the underscore, not a wildcard. > > Thanks, > Norris
