Sql server query multiple pattern

Question

I want to match multiple patterns from a table.

I have five different names and query should fetch all records that have those name/string listed.

Regards, Nawab

Your question is not clear, perhaps add some details and some of your code so that anyone can help. — Nikhil Girraj
– Nikhil Girraj, Commented Oct 29, 2014 at 8:00

mlinth · Accepted Answer · 2014-10-29 08:02:57Z

2

SELECT * FROM mytable where mycolumn in ('Name1','Name2','Name3')

If you are pattern matching with wildcards you need something like:

   SELECT * from mytable 
    WHERE mycolumn LIKE'%name1%' 
    OR mycolumn LIKE'%name2%' 
    -- add more OR conditions

answered Oct 29, 2014 at 8:02

mlinth

3,1586 gold badges35 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vijaya Edke · Accepted Answer · 2017-05-11 19:16:26Z

0

Select * from mytable where columnname like pattern
union 
Select * from mytable where columnname like pattern;

For matching the multiple pattern, simply replace the pattern

Select name,id from emp where name like 'A%'
union 
Select name,id from emp where name like 'Z%'

answered Mar 7, 2017 at 18:02

Vijaya Edke

212 bronze badges