Difference between revisions of "Like"

Latest revision as of 13:08, 12 July 2012

How do I use LIKE in a sql SELECT statement.

schema:gisq

The LIKE command allows "Wild cards". A % may be used to match and string, _ will match any single character.

The example shows countries begining with Z. The country Zambia matches because ambia matches with the %.

SELECT name FROM bbc
WHERE name LIKE 'Z*'

SELECT name FROM bbc
WHERE name LIKE 'Z%'

@@ Line 1: / Line 1: @@
 How do I use LIKE in a sql SELECT statement.
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <div>
 The LIKE command allows "Wild cards".
@@ Line 10: / Line 10: @@
 The country Zambia matches because ambia matches with the %.
 </div>
-<source lang=sql class='tidy'>DROP TABLE bbc;
+<source lang=sql class='tidy'></source>
-DROP TABLE actor;</source>
+<source lang=sql class='setup'></source>
-<source lang=sql class='setup'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
-INSERT INTO bbc VALUES ('Poland', 'Europe');
-INSERT INTO bbc VALUES ('Japan', 'Asia');
-INSERT INTO bbc VALUES ('Zambia', 'Africa');</source>
 <source lang='sql' class='def e-access'>SELECT name FROM bbc
 WHERE name LIKE 'Z*'</source>