Difference between revisions of "SQL"

From RHS Wiki
Jump to navigation Jump to search
(Created page with "== LIKE patterns == {| class="wikitable" |- ! Wildcard !! Meaning |- | % || Any string of zero or more characters. |- | _ || Any single character. |- | [ ] || Any single chara...")
 
Line 1: Line 1:
 +
SQL
 
== LIKE patterns ==
 
== LIKE patterns ==
 
{| class="wikitable"
 
{| class="wikitable"

Revision as of 06:53, 18 August 2015

SQL

LIKE patterns

Wildcard Meaning
% Any string of zero or more characters.
_ Any single character.
[ ] Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]).
[^] Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]).