I need to find all records where login has an underscore in them. I know it has something to do with ESCAPE, since _ matches a single character, but I cant seem to get the syntax correct. Here is what im intending to do, even though this obviously doesnt do it:
SELECT * from users where login LIKE '%_%'; Can anyone suggest a proper statement that escapes the underscore, so the above will work as intended? Thank you! Joe Noon