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
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