Question

Query to select all records with "bar" in their name?

 SELECT * FROM people WHERE name = "%bar%";

 SELECT * FROM people WHERE name LIKE "%bar%";

 SELECT * FROM people WHERE name IN ("bar");

 SELECT * FROM people WHERE name = "_bar_"