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 co
Jessica Richard <[EMAIL PROTECTED]> writes:
> 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?
Using LIKE, you don't. However there are two other types of
pattern-matching operators that do understand character classes:
http://www
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?
Thanks.
-
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's update