MySQL Query improvement

Question

I need to filter an DB, but my selection is too big for the DBeaver that i'm using. Is it possible to make it different?

CustomersAffected IS NULL 
AND Node NOT LIKE 'CTA%' 
AND Node NOT LIKE 'OCO%' 
AND Node NOT LIKE 'SJC%' 
AND Node NOT LIKE 'MUA%' 
AND Summary NOT LIKE 'Device Not%' 
AND Summary NOT LIKE 'Wireless%' 
AND Description NOT LIKE 'CLI%'

What do you mean by *"my selection is too big"* ? You're getting too much results? — Cid, Dec 08 '21 at 19:20

score 0 · Accepted Answer · answered Dec 08 '21 at 19:42

0

It can be compressed using REGEXP

CustomersAffected IS NULL
AND Node NOT REGEXP 'CTA|OCO|SJC|MUA'
AND Summary NOT REGEXP 'Device Not|Wireless'
AND Description NOT LIKE 'CLI%'

answered Dec 08 '21 at 19:42

chaos505

468
3
10

MySQL Query improvement

1 Answers1