mysql LIKE operator not matching the condition appropriately

Question

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?

John Woo · Accepted Answer · 2013-04-04 09:32:13Z

4

you need to _ because it is a wildcard

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

SQLFiddle Demo

or

SELECT * FROM tablename WHERE token LIKE 'v|_%' ESCAPE '|';

MySQL LIKE

answered Apr 4, 2013 at 9:32

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

asprin Over a year ago

Nice. +1 and accepting as answer. Got to learn a new thing today.

Collectives™ on Stack Overflow

mysql LIKE operator not matching the condition appropriately

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related