SQL data that contains | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

SQL data that contains

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

7th Jan 2022, 5:35 PM
Josué Hinestroza
Josué Hinestroza - avatar
3 Answers
+ 1
like '%NY%'
7th Jan 2022, 6:04 PM
Alex
Alex - avatar
0
I'm actually trying that in GOOGLE Sheets with function query %NY% but it does not filter
7th Jan 2022, 6:05 PM
Josué Hinestroza
Josué Hinestroza - avatar
0
"does not filter" means everything or nothing in the result? What's the whole statements?
7th Jan 2022, 6:12 PM
Alex
Alex - avatar