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...")
(No difference)

Revision as of 06:52, 18 August 2015

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]).