Solve SQL query | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis
+ 1

Solve SQL query

9.Find the countries that have two "o" characters separated by two other characters

31st Aug 2020, 11:20 AM
Mohd Aadil
Mohd Aadil - avatar
8 Respostas
+ 1
Mohd Aadil It should be LIKE '%o__o%';
31st Aug 2020, 11:28 AM
ŠœŠ³. ŠšŠ½Š°ŠæšŸŒ 
ŠœŠ³. ŠšŠ½Š°ŠæšŸŒ  - avatar
+ 5
What have you tried? did it work?
31st Aug 2020, 11:22 AM
Ipang
+ 3
Can you share your query here? maybe we can work something out ...
31st Aug 2020, 11:23 AM
Ipang
+ 2
Something like "Cordova" string it has two characters between two "o"s right?
31st Aug 2020, 11:26 AM
ŠœŠ³. ŠšŠ½Š°ŠæšŸŒ 
ŠœŠ³. ŠšŠ½Š°ŠæšŸŒ  - avatar
31st Aug 2020, 11:30 AM
Mohd Aadil
Mohd Aadil - avatar
+ 1
It didn't work
31st Aug 2020, 11:23 AM
Mohd Aadil
Mohd Aadil - avatar
+ 1
Okay Ipang SELECT COUNTRY FROM WORLD WHERE COUNTRY LIKE '__o__o' I'm trying this
31st Aug 2020, 11:26 AM
Mohd Aadil
Mohd Aadil - avatar
31st Aug 2020, 11:28 AM
Mohd Aadil
Mohd Aadil - avatar