convert REGEXP to LIKE in MYSQL query

Question

I have MYSQL query that looks as below

select * from table1 where host REGEXP 'host1';

I want to execute the same query using LIKE Please suggest how it can be achieved

Tim Biegeleisen · Accepted Answer · 2017-07-04 06:39:45Z

3

Try this:

select * from table1 where host LIKE '%host1%';

REGEXP 'host1' will match host1 anywhere in the string. To phrase this using the LIKE operator we need to surround host1 with wildcards.

answered Jul 4, 2017 at 6:33

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

2 Comments

@Phil Based on this demo it seems that your comment is mistaken.

Seems you are correct and reality differs to expectations

Madhivanan · Accepted Answer · 2017-07-04 06:34:07Z

0

You can try using %

select * from table1 where host LIKE '%host1%';

answered Jul 4, 2017 at 6:34

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges