Jessica Richard wrote:
If I have a column with a value like "abc2457", "efg1234",
how do I select col from table where col like 'a[a-z]c24[0-9]7"?
How do I handle the range bracket in the query?
You can use the regular expression operator(s), like so:
select *
from table
where column ~ 'a[a-z]c24[0-9]7';
For the full details:
http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#AEN9312
-Jon
--
Senior Systems Developer
Media Matters for America
http://mediamatters.org/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
