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