MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.6.47


create table user(ID int,NAME char(64),IMG_HASH varchar(32));
insert into user values(1,'Name1',96);
insert into user values(2,'Name1 ABC',96);
insert into user values(3,'Name2 ABC',100);
insert into user values(4,'Name3 ABC',99);
insert into user values(5,'Name4 ABC',85);
insert into user values(6,'Name5 ABC',54);

SELECT * FROM user WHERE name RLIKE 'Name1|Name2|Name3'




ID
NAME
IMG_HASH


1
Name1
96

2
Name1 ABC
96

3
Name2 ABC
100

4
Name3 ABC
99


SELECT * FROM user WHERE name  regexp concat_ws("|","name1", "name2", "name3");


ID
NAME
IMG_HASH


1
Name1
96

2
Name1 ABC
96

3
Name2 ABC
100

4
Name3 ABC
99