Snowflake Training Udemy _verified_ Here

SELECT * FROM mytable WHERE name = 'John';