mysql>
select
'123|124|125'
regexp
'123|126'
;
+
--------------------------------+
|
'123|124|125'
regexp
'123|126'
|
+
--------------------------------+
| 1 |
+
--------------------------------+
1 row
in
set
(0.00 sec)
mysql>
select
'122|124|125'
regexp
'123|126'
;
+
--------------------------------+
|
'122|124|125'
regexp
'123|126'
|
+
--------------------------------+
| 0 |
+
--------------------------------+
1 row
in
set
(0.00 sec)
mysql>