mysql – Like Function to RegexP
Basically I have below query.
Select * from testtabel
where call_id like '%7534567'
or call_id like '%7134576' or ..... ;
7534567,7134576 are not any pattern. So I need to check any call_id which ends 7534567 or 7134576. since I have many to check without using LIKE can I use regexp to check that?
refered Using multiple values in mySQL regexp and
I tried as below,
Select * from testtabel where call_id REGEXP '^(7534567|7134576)$';
But this provides zero records. Can someone show me how should I do that?
Read more here: Source link