WHERE a='b'means the predicate on the column
aequals to a string literal value
WHERE a="b"means the predicate on the column
aequals to the value of the column
date, or other reserved keywords, or the column name includes special characters, you need to use double quotes when you refer to them in the query.