Re: [sqlite] finding records with an underscore using like

On Oct 7, 2005, at 10:21 PM, Joe Noon wrote: 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

[sqlite] finding records with an underscore using like

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