select 'example@email.com' ~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$'
select 'example@email.com' ~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$'
select substring(
'http://www.example.com/page' from '://([^/]+)'
) = 'www.example.com'
select substring(
'http://www.example.com/page' from '://([^/]+)'
) = 'www.example.com'
select 'www.example.net' ~ '\.org$'
select 'www.example.net' ~ '\.org$'
select 'The quick brown fox' ~ '\mbrown\b'
select 'The quick brown fox' ~ '\mbrown\b'
select '192.168.300.1' ~ '^(\d{1,3}\.){3}\d{1,3}$'
select '192.168.300.1' ~ '^(\d{1,3}\.){3}\d{1,3}$'
select 'g3h4' ~ '^[A-Fa-f0-9]+$'
select 'g3h4' ~ '^[A-Fa-f0-9]+$'
select '2023/04/01' ~ '^\d{4}-\d{2}-\d{2}$'
select '2023/04/01' ~ '^\d{4}-\d{2}-\d{2}$'
select '123-456-789' ~ '^\d{3}-\d{2}-\d{4}$'
select '123-456-789' ~ '^\d{3}-\d{2}-\d{4}$'
select '(123) 456-7890' ~ '^\(\d{3}\) \d{3}-\d{4}$'
select '(123) 456-7890' ~ '^\(\d{3}\) \d{3}-\d{4}$'
select 'abcxyz' ~ '[0-9]+'
select 'abcxyz' ~ '[0-9]+'
select 'password' ~ '^(?=.*[A-Za-z])(?=.*\d)[A-Za-z\d]{8,}$'
select 'password' ~ '^(?=.*[A-Za-z])(?=.*\d)[A-Za-z\d]{8,}$'
select 'hello' ~ '^[A-Z]+$'
select 'hello' ~ '^[A-Z]+$'
select '123456' ~ '^\d{5}$'
select '123456' ~ '^\d{5}$'
select 'www.example.com' ~ '^https?://[a-z0-9.-]+(\.[a-z]{2,})+$'
select 'www.example.com' ~ '^https?://[a-z0-9.-]+(\.[a-z]{2,})+$'
select '1234-5678-9012-3456' ~ '^\d{4}-\d{4}-\d{4}-\d{4}$'
select '1234-5678-9012-3456' ~ '^\d{4}-\d{4}-\d{4}-\d{4}$'
select 'image.png' ~ '\.pdf$'
select 'image.png' ~ '\.pdf$'
select 'XYZ7890' ~ '^[A-Z]{3}-\d{4}$'
select 'XYZ7890' ~ '^[A-Z]{3}-\d{4}$'
select 'abc-123' ~ '^[A-Za-z0-9]+$'
select 'abc-123' ~ '^[A-Za-z0-9]+$'