MySQL LIKE more results than expected

Question

Why does this LIKE-statement

WHERE configuration_key LIKE 'MODULE_SHIPPING_DP_%'

shows results like this:

MODULE_SHIPPING_DPD_STATUS
MODULE_SHIPPING_DP_STATUS
MODULE_SHIPPING_DPD_TAX_CLASS
MODULE_SHIPPING_DP_TAX_CLASS

I only wanted to get results with

MODULE_SHIPPING_DP_foobar

I dind't get it.

score 2 · Accepted Answer · answered Apr 10 '13 at 18:05

2

Because underscore _ is like the % except you only look for one character (cf documentation)

You need to escape the character by using \ before like this :

WHERE configuration_key LIKE 'MODULE\_SHIPPING\_DP\_%'

answered Apr 10 '13 at 18:05

DessDess

How could I solve it for determination of MODULE_SHIPPING_DPD_ and MODULE_SHIPPING_DP_ ? – user1286819 Apr 10 '13 at 18:08

score 1 · Answer 2 · answered Apr 10 '13 at 18:09

1

_ is also a wildcard, matching one character. So you need to escape it.

WHERE configuration_key LIKE 'MODULE\_SHIPPING\_DP\_%'

answered Apr 10 '13 at 18:09

James Scholes

2 Answers2