Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Pattern Matching

Question:
How can I use SQL to specify a query like the example below:
    select * from mytable where column like 'a[bc]'
This should match both "ab" and "ac" but not "ad."

Answer:
SQL does not have strong pattern matching facilities. For the example you've provided, you'll have to construct the query using the IN predicate:

    SELECT * FROM MyTable 
        WHERE col IN (ab, ac);
If your list is extensive, you might want to use a subquery:
    SELECT * FROM MyTable 
        WHERE col IN 
            (SELECT value FROM ValueTable);
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date