CODEWITHSUNDEEP
mysqlsqlescaping
bigdaveygeorge
bigdaveygeorge

Reputation: 999

MySQL underscore with LIKE Operator

I have an SQL query which matches results using a LIKE :

_column_name_%

This will return results where the column name is:

_column_name_1
_column_name_2

The end number could be a really high number e.g. 32523, or even 523624366234.

If I use _column_name_%%%%% this would match 32523, but not 523624366234.

How would I get the LIKE to match without typing % repeatedly?

Upvotes: 0

Views: 2073

Answers (1)

kuma DK
kuma DK

Reputation: 1861

A Simple select query with the LIKE operator should look like this

You have to escape the underscore using "\" if you are having any.

instead of pretext_% use pretext\_%

Select * from mytable where field_1 like 'pretext\_%'

This will return pretext_1 as well as pretext_11

Upvotes: 4

Related Questions