Query - where 'field' IN (array of wildcarded strings) - possible?

[Lemon_Juice]

@Mittineague

But short of building a query that uses ORs

OR field LIKE “%his”;
OR field LIKE “tha%”;
OR field LIKE, “%nothe%”;

I know of no way to pass an array of wildcarded strings to a MySQL WHERE

Impossible?

You can use REGEXP:

SELECT field FROM table WHERE field REGEXP '(his$|^tha|nothe)'

However, regular expressions in MySQL are quite primitive, for example they will not work well with utf-8 character sets.

@Mittineague

Maybe it could be done using a database other than MySQL?

Postgresql has very good regular expression support and will work for utf-8 characters as well, so it is better suited for languages other than English or Latin in this case (however, much more limited in the choice of collations).