Mysql正则表达式，有点复杂

I got a table in my database with field of "Name", one cell can contain more than one name by '|' that breaks them, for ie: 'NAME1|NAME2|NAME3' or another cell: 'NAME1'. I want to select all the rows that contains the EXACT name, the problem is, lets say someone searching for 'BLABLANAME1' or just 'NAME' or 'AME1', none of this should return him the row, I tried the following:I got a table in my database with field of "Nam