Query to select var REGEX MANY columns

Question

Here is what I was want to Optimize this query

SELECT * 
FROM users 
where `username` like "%abc%" 
   or `name`     like "%abc%" 
   or `email`    like "%abc%"

This search get result from users where any of username , name , email like %abc%

So I tried to use in with like But

I was looking for mysql Like in and I have found this answer stackoverflow :Mysql like in

So the solution was regex

But I want to make the regex not use OR

I want to be like this

SELECT * from users where abc REGEXP 'username|name|email';

So the answer

Ωmega · Accepted Answer · 2012-09-23 13:25:21Z

1

Do you mean something like this? >>

SELECT * from users where CONCAT(username, ',', name, ',', email) REGEXP 'abc'

answered Sep 23, 2012 at 13:25

Ωmega

44k35 gold badges143 silver badges213 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mona Abdelmajeed Over a year ago

Your query is very good for me , and the same result work with LIKE statment Is there any diffrent between regex and like with your query

Ωmega Over a year ago

@MonaAbdelmajeed - Your question asks for regex solution, so I used REGEXP in the example. In this case, you will get same results if you use like or REGEXP. However for more complex search/match patterns REGEXP is better choice...

Collectives™ on Stack Overflow

Query to select var REGEX MANY columns

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related