Postgres 15

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

create table mytable (
  phoneNumber varchar(20)
);

insert into mytable values
('318015042159'),
('318114438818');

CREATE TABLE

INSERT 0 2

select phoneNumber 
from mytable t 
where substring(phoneNumber from '^3180(\d{8})') IN ('15042159','14438818')

phonenumber

318015042159

SELECT 1

select phoneNumber  
from mytable t 
where substring(phoneNumber from '^(?:3180|3181)(\d{8})') IN ('15042159','14438818')

phonenumber

318015042159

318114438818

SELECT 2