Simplify query select

Databases
1

Hello everyone, I need your help.

You can simplify this query in MySQL?


SELECT * FROM _tbl
   where 
     uo like '%M2%'
  or uo like '%M4%'
  or uo like '%M7%'
  or uo like ......
  or uo like ......

Thanks in advance-

2

no, sorry

:slight_smile:

3

Do you have something personal against me? :shifty:

4

No, his point is that query cannot be simplified. It’s not like when you’re seaching for distinct values and you can use the IN operator.

Using the LIKE forces each comparison to be done individually.

5

How can we simplify a query, when you don’t give us the full query to begin with?

From the looks of it, no is the answer.

6

Full query ?


SELECT * FROM _tbl
   where 
     uo like '%M2%'
  or uo like '%M4%'
  or uo like '%M6%'
  or uo like '%M7%'
  or uo like '%I1%'
  or uo like '%I5%'
  or uo like '%I6%'
  or uo like '%S1%'
7

Ok, then i point to Dave’s reply

8

oh, wait, i think you could also do this …


WHERE uo REGEXP 'M2|M4|M6|M7|I1|I5|I6|S1'

but it will be just as inefficient as the LIKE solution

9

Thanks for your help. :slight_smile: