Is there a way to do Like against a list of Values?

Question

Is there a way to mix LIKE operator with IN ? Something Like

SELECT Id FROM Account WHERE Name LIKE IN:nameList

Where nameList is list of String? Is this is possible ? (I can make a dynamic query by doing OR with all the elements, but was looking for a more elegant way to do this)

You can't do a LIKE with IN. You have to use the OR query. Or maybe you can use SOSL. — user254875486, Jun 06 '13 at 08:27

score 97 · Accepted Answer · edited Aug 11 '23 at 16:48

97

No, but you can query like this which does the same thing as what you're trying to do:

String[] filters = new String[]{'acme%','ib%'};
List<Accounts> accs = [SELECT Id, Name FROM Account WHERE Name LIKE :filters];

edited Aug 11 '23 at 16:48

fred

3,335
3
16
27

answered Jun 06 '13 at 08:48

drakored

2,698
15
17

That's a neat solution to the problem. – Doug B Jun 06 '13 at 08:56
ahhh really neat. Somehow thought IN can only operator on collections – Avidev9 Jun 06 '13 at 08:56
Yea this method is a huge time saver. Also, with using the OR option, you run into the query length limitation eventually. – drakored Jun 06 '13 at 08:59
NIce solution, +1! – Sergej Utko Jun 06 '13 at 11:14
fantastic solution!! my upvote for this...I thought there would be no option to do a like for multiple strings. Fortunately i found this. Thanks drakored!! – Bforce Jul 27 '14 at 21:14
Is this documented or did you just find this out by trial and error? – Caspar Harmer Apr 22 '15 at 00:09
Trial and error, although it might be documented, not sure. – drakored Apr 26 '15 at 18:29
man, it's a shame it's not clearly documented, this is a pretty sweet syntax to hide – Ralph Callaway May 03 '17 at 20:21

Is there a way to do Like against a list of Values?

1 Answers1

Linked

Related