Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server / SQL-Server-2008R2

To Search Data in Multiple Columns using 'IN' Clause

4.87/5 (25 votes)
21 May 2015CPOL 29.7K  
To search data in multiple columns using 'IN' clause

Introduction

Let me show you how to search a record from multiple columns in a table by using Simple 'IN' Clause in SQL Server.

Using the Code

  1. Create a table with some dummy records to  show the demonstration:
    SQL
    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'.
    SQL
    select *from tbl_test where 'Griff' IN (column1,coulmn2,coulmn3)
  3. By executing the above query, we will get the resultset like below:
    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.

Yeah, it's very simple, but I hope it's a very helpful tip.

History

  •  Created and published on May 22nd, 2015

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)