1

I'm using a query such as

SELECT * FROM tablename WHERE token LIKE 'v_%'

This is resulting in records whose token starts with v_ (which is exactly what I want) but it is also showing records which start with just v (screenshot attached)

enter image description here

Why is this happening? Am I missing something?

MPelletier
  • 16,256
  • 15
  • 86
  • 137
asprin
  • 9,579
  • 12
  • 66
  • 119

1 Answers1

4

you need to _ because it is a wildcard

SELECT * FROM tablename WHERE token LIKE 'v\_%'

or

SELECT * FROM tablename WHERE token LIKE 'v|_%' ESCAPE '|';
John Woo
  • 258,903
  • 69
  • 498
  • 492