SQL data that contains

Question

I have too many addresses and want to select all that contains NY I forgot what WA stje command to select all cities that contain NY in it

Answer 1

like '%NY%'

Answer 2

I'm actually trying that in GOOGLE Sheets with function query %NY% but it does not filter

Answer 3

"does not filter" means everything or nothing in the result?

What's the whole statements?