SQL Query Multiple LIKE

Question

currently I'm making something.

using (var IDatabaseQuery = Lightningbolt.GetDatabaseManager().CreateQueryObject())
        {
            IDatabaseQuery.SetQuery("SELECT * FROM catalogue_baseitems WHERE name LIKE '%hc2_%' OR name LIKE '%hc3_';");
            data = IDatabaseQuery.FetchTable();
        }

That's what I use, I want to get all the items beginning with hc2_ and hc3_, however, I only get the items starting with hc2_. In the SQL contains also items starting with hc3_ but it doesn't show while executing the query. What do I wrong?

Ed Gibbs · Accepted Answer · 2013-05-09 20:41:25Z

3

If you want items beginning with hc2_ or hc3_, you need to make two changes:

Don't use the % at the beginning, and
Escape the underscore because it masks to "any one character"

Try something like this:

SELECT * FROM catalogue_baseitems WHERE name LIKE 'hc2\_%' OR name LIKE 'hc3\_%'

Note that %hc2_% will match any of the following examples:

abchc2X (because of the leading % and the underscore will match the X)
hc23 (because underscore will match the 3)
... and so on

answered May 9, 2013 at 20:41

Ed Gibbs

26.4k4 gold badges50 silver badges75 bronze badges

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

Comments

Dominic P · Accepted Answer · 2013-05-09 20:39:50Z

1

You are missing the second percent sign: '%hc3_%'

answered May 9, 2013 at 20:39

Dominic P

2,9411 gold badge16 silver badges16 bronze badges

1 Comment

Joshua Bakker Over a year ago

Thanks, that worked well. I did some dirty quick work so I must've forgotten the second percent sign.

Sachin · Accepted Answer · 2013-05-09 20:45:44Z

1

You want result which contains hc2_ and hc3_ at the beginning then you need to use clause like this 'hc2_%' or hc3_%.

You are getting results for hc2_ because you are using '%hc2_%', this return any string which contains hc2_ anywhere in the string.

Change your query to this

IDatabaseQuery.SetQuery("SELECT * FROM catalogue_baseitems WHERE name LIKE 'hc2\_%' OR name LIKE 'hc3\_%';");

and don't forgot about underscore(_), this is a wildcard character.

edited May 9, 2013 at 20:45

answered May 9, 2013 at 20:39

Sachin

41.1k7 gold badges94 silver badges107 bronze badges

Collectives™ on Stack Overflow

SQL Query Multiple LIKE

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related