You need a regular expression that checks whether the text contains words - qwe , asd , zxc , they can be part of the word. If done in order qwe.*asd.*zxc.* , It is possible through | List all possible variants of sequences, and how to make this task easier?
Type:
SELECT 'Π½Π°Π±ΠΎΡ ΡΠΈΠΌΠΎΠ²Π»ΠΎΠ²' REGEXP 'ΡΠ΅Π³ΡΠ»ΡΡΠ½ΠΎΠ΅ Π²Π°ΡΠ°ΠΆΠ΅Π½ΠΈΠ΅'; 
I need them all to meet
(?=.*qwe)(?=.*asd)(?=.*zxc) 
something like this (will return 1 if one of the combinations matches):
select 'Π½Π°Π±ΠΎΡ ΡΠΈΠΌΠΎΠ²Π»ΠΎΠ²' regexp 'qwe|asd|zxc'; and if you want the string to have all three combinations, then something like this:
select 'Π½Π°Π±ΠΎΡ ΡΠΈΠΌΠΎΠ²Π»ΠΎΠ²' regexp 'qwe' and 'Π½Π°Π±ΠΎΡ ΡΠΈΠΌΠΎΠ²Π»ΠΎΠ²' regexp 'asd' and 'Π½Π°Π±ΠΎΡ ΡΠΈΠΌΠΎΠ²Π»ΠΎΠ²' regexp 'zxc'; 
Regulars here are not needed for nothing.
Check whether the field contains a substring, you can operator LIKE. Conditions in the WHERE can be any number.
If it is necessary that they are all executed, then they must be listed through AND
Source: https://ru.stackoverflow.com/questions/427497/
All Articles