To Search Data in Multiple Columns using 'IN' Clause

Using the Code

1. Create a table with some dummy records to  show the demonstration:
   Hide    Copy Code

   create table tbl_test
   (id int identity(1,1),
   column1 nvarchar(50),
   coulmn2 nvarchar(50),
   coulmn3 nvarchar(50))-- Create a table 
   insert into tbl_Test (column1,coulmn2,coulmn3) values
   ('Griff','Serjey','Maciej'),
   ('King','Fisher','Ajay'),
   ('Paul','Griff','Serjey'),
   ('King','Fisher','Griff')--Inserting some Dummy Records

2. Now, I'm going to search the value where the data is 'Griff'. In the above table, there are 3 rows that contain 'Griff'.
   Hide    Copy Code

   select *from tbl_test where 'Griff' IN (column1,coulmn2,coulmn3)

3. By executing the above query, we will get the resultset like below:
   Hide    Copy Code

   id   column1    coulmn2    coulmn3
   1    Griff      Serjey    Maciej
   3    Paul       Griff     Serjey
   4    King       Richard   Griff

The query will check all the mentioned columns where the input data is available by using the simple 'IN' clause.

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/wupd2014/p/4975507.html