Untitled

Regular expression: Postgres SQL query is returning all records available in the table
Employee table contains :

name
Chennai
Delhi
Hydrabad
NewYark
ABC

select * from employee where name ~ 'Z*'

SELECT record FROM myrecords WHERE name LIKE 'Z%';

SELECT record FROM myrecords WHERE name ~ '^Z';

SELECT record FROM myrecords WHERE name LIKE '%Z%';
SELECT record FROM myrecords WHERE name ~ 'Z';

SELECT record FROM myrecords WHERE name ~ '^Z';

select * from employee where name ~ 'Z*'