I'm having an issue using the % wildcard with a MySQL query.

Having read that article, I am using % and not getting quite what I was expecting.

I have a series of values, such as

1_1
1_2
2_1
2_2... etc

including

11_1
11_2

Now, in some cases I want to return specifically those whose value = 11_2, or 1_2 etc. This works fine

WHERE fieldName = '11_2'

etc... as expected

However, in some cases I want to find all items which start with a 1 or all items which start with 11

From the w3Schools link, I was expecting

WHERE fieldName LIKE '1_%'

To find anything that begins with 1_ specifically, therefore, in my example, returning:

1_1
1_2

BUT, it also returns

11_1
11_2

Why is this? And how can I over come it?

1 Answer

Underscore is a wildcard for a single character. You will need to change your SQL to something like:

WHERE fieldName LIKE '1%'

Or you can escape the underscore

WHERE fieldName LIKE '1\_%' 

0

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy