Created
July 13, 2009 05:15
-
-
Save dburger/145946 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- mysql has an default escape character \ | |
SELECT * FROM people WHERE symbol LIKE 'hello\_world'; | |
-- or you can specify the escape character | |
SELECT * FROM people WHERE symbol LIKE 'hello|_world' ESCAPE '|'; | |
-- tsql has no default but you can go with a single character class | |
SELECT * FROM people WHERE symbol LIKE 'hello[_]world'; | |
-- or you can specify an escape character | |
SELECT * FROM people WHERE symbol LIKE 'hello|_world' ESCAPE '|'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment