SQL

Join Example

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;

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