SQL data that contains | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
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 Réponses
+ 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