2,306
edits
Changes
Jump to navigation
Jump to search
mLine 1:
Line 1: − SQL+ − + + + + + + + − + − + − + − + − +
no edit summary
== Join Example ==
== LIKE patterns ==
<syntaxhighlight lang="sql">
select common_net.id, common_net.net, common_net.mask, common_net.cidr, common_country.description, common_country.code
FROM common_net
INNER JOIN common_country ON common_country.id=common_net.country_id;
</syntaxhighlight>
==LIKE patterns==
{| class="wikitable"
{| class="wikitable"
|-
|-
! Wildcard !! Meaning
!Wildcard!!Meaning
|-
|-
| % || Any string of zero or more characters.
|%||Any string of zero or more characters.
|-
|-
| _ || Any single character.
|_||Any single character.
|-
|-
| [ ] || Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]).
|[ ]||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]).
|[^]||Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]).
|}
|}