Is there a combination of LIKE and IN in SQL

Question

Unfortunately, I frequently utilize "LIKE" criteria in SQL because of databases that blatantly disregard all normalization rules. Right now, I can't change it. However, that has no bearing on the inquiry. In addition, I frequently utilize conditions like WHERE something in (1,1,2,3,5,8,13,21) to make my SQL queries easier to comprehend and more flexible.

Is it possible to combine these two things without having to create laborious sub-selects?

Instead of this, I would prefer something as simple as WHERE something LIKE ('bla%', '%foo%', or 'batz%'):

WHERE something LIKE 'bla%'
OR something LIKE '%foo%'
OR something LIKE 'batz%'

I'm working with SQL Server and Oracle here but I'm interested if this is possible in any RDBMS at all. Can someone please help me with this?

Answer 1

There is no LIKE & IN combination in either SQL or TSQL (SQL Server), much less PLSQL (Oracle). The fact that Full-Text Search (FTS) is the suggested substitute contributes to this.

The CONTAINS keyword is supported by both Oracle and SQL Server FTS implementations, however, the syntax is still a little different:

Oracle:

WHERE CONTAINS(t.something, 'bla OR foo OR batz', 1) > 0

SQL Server:

WHERE CONTAINS(t.something, '"bla*" OR "foo*" OR "batz*"')

I hope this helps you. 

If you need to know more about SQL, it is recommended to go for the SQL Course today.