AWS Athena: how to use LIKE in the query

Question

I have a row which has the word "cool" in "tweet" column:

SELECT * FROM tweets LIMIT 10

However, when I execute query using LIKE to find that record, nothing shows up:

SELECT * FROM tweeets WHERE 'tweet' LIKE '%cool%'

Did I do anything wrong?

Is it because I have double quote around the column name "tweet"? I tried to remove it but then I received a COLUMN_NOT_FOUND error.

Anything tip will be appreciated.