Difference between revisions of "SELECT names"

From SQLZOO
Jump to: navigation, search
Line 24: Line 24:
  
 
   <div class='extra_space' style='width:1em; height:6em;'></div>
 
   <div class='extra_space' style='width:1em; height:6em;'></div>
 
+
 
 
<div class='qu'>
 
<div class='qu'>
 
You can use <code>WHERE name LIKE 'B%'</code> to find the countries that start with "B".
 
You can use <code>WHERE name LIKE 'B%'</code> to find the countries that start with "B".
Line 38: Line 38:
 
SELECT name FROM world
 
SELECT name FROM world
 
   WHERE name LIKE 'Y%'
 
   WHERE name LIKE 'Y%'
 +
</source>
 +
</div>
 +
 +
 +
<div class='qu'>
 +
<p class='imper'>Find the countries that end with '''y'''</p>
 +
 +
<source lang='sql' class='def'>
 +
SELECT name FROM world
 +
  WHERE name LIKE 'T%'
 +
</source>
 +
 +
<source lang='sql' class='ans'>
 +
SELECT name FROM world
 +
  WHERE name LIKE '%y'
 +
</source>
 +
</div>
 +
 +
<div class='qu'>
 +
<p class='imper'>Find the country that contain the letter '''x'''</p>
 +
 +
<source lang='sql' class='def'>
 +
SELECT name FROM world
 +
  WHERE name LIKE 'T%'
 +
</source>
 +
 +
<source lang='sql' class='ans'>
 +
SELECT name FROM world
 +
  WHERE name LIKE '%x%'
 
</source>
 
</source>
 
</div>
 
</div>

Revision as of 20:56, 20 November 2014

namecontinent
AfghanistanAsia
AlbaniaEurope
AlgeriaAfrica
AndorraEurope
AngolaAfrica
....

Pattern Matching Strings

This tutorial uses the LIKE operator to check names. We will be using the SELECT command on the table world:

Summary

You can use WHERE name LIKE 'B%' to find the countries that start with "B".

  • The % is a wild-card it can match any characters

Find the country that start with Y

SELECT name FROM world
  WHERE name LIKE 'F%'
SELECT name FROM world
  WHERE name LIKE 'Y%'


Find the countries that end with y

SELECT name FROM world
  WHERE name LIKE 'T%'
SELECT name FROM world
  WHERE name LIKE '%y'

Find the country that contain the letter x

SELECT name FROM world
  WHERE name LIKE 'T%'
SELECT name FROM world
  WHERE name LIKE '%x%'