How to decrease the query (NOT) LIKE?

I have a query with a bunch of NOT LIKE. They all belong to the same column in the table.
For example:
item_type NOT LIKE ? AND item_type NOT LIKE ? AND item_type NOT LIKE ? AND item_type NOT LIKE ? -- etc.


How is it possible to reduce the SQL language? And how it can be reduced in Rails?
July 9th 19 at 10:58
1 answer
July 9th 19 at 11:00
Solution
It all text? If Yes, then only if the regexp.

If not the text(and if the text is accurate, and not part of the %% line, it is also possible to not in), then why, like, do the normal and not in
There are many different words, using %. - alfonzo.Zeml commented on July 9th 19 at 11:03
: then just regexp - bailee_Stant commented on July 9th 19 at 11:06
: could you please demonstrate the regexp in SQL small example? And then I'm stuck. Nothing specific to Google on my topic. - alfonzo.Zeml commented on July 9th 19 at 11:09
: https://stackoverflow.com/questions/5901903/using-... - bailee_Stant commented on July 9th 19 at 11:12
: in, thank you :) - alfonzo.Zeml commented on July 9th 19 at 11:15

Find more questions by tags MySQLRuby on RailsPostgreSQL