Like - Revision history

Marek at 13:08, 12 July 2012

2012-07-12T13:08:53Z

Marek at 11:11, 12 July 2012

2012-07-12T11:11:52Z

Marek at 11:18, 11 July 2012

2012-07-11T11:18:05Z

Marek: Created page with "How do I use LIKE in a sql SELECT statement.

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

2012-07-11T08:30:08Z

Created page with "How do I use LIKE in a sql SELECT statement. <div class='ht'> <div> The LIKE command allows "Wild cards". A % may be used to match and string, _ will match any single characte..."

New page

How do I use LIKE in a sql SELECT statement.
<div class='ht'>
<div>
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 %.
</div>
<source lang=sql class='tidy'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
INSERT INTO bbc VALUES ('Poland', 'Europe');
INSERT INTO bbc VALUES ('Zambia', 'Africa');
</source>
<source lang='sql' class='def e-access'>SELECT name FROM bbc
WHERE name LIKE 'Z*'</source>
<source lang='sql' class='def'>SELECT name FROM bbc
WHERE name LIKE 'Z%'</source>
<div class="ecomm e-access" style="display: none">Use * to match any sequence and ? to match a single character.</div>
</div>

@@ 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>

← Older revision		Revision as of 11:18, 11 July 2012
Line 19:		Line 19:
	<div class="ecomm e-access" style="display: none">Use * to match any sequence and ? to match a single character.</div>		<div class="ecomm e-access" style="display: none">Use * to match any sequence and ? to match a single character.</div>
	</div>		</div>
		+
		+	{{SELECT Ref}}

Like - Revision history

Marek at 13:08, 12 July 2012

Marek at 11:11, 12 July 2012

Marek at 11:18, 11 July 2012

Marek: Created page with "How do I use LIKE in a sql SELECT statement. The LIKE command allows "Wild cards". A % may be used to match and string, _ will match any single characte..."

Marek: Created page with "How do I use LIKE in a sql SELECT statement.

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