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
- Create a table with some dummy records to show the demonstration:
create table tbl_test
(id int identity(1,1),
column1 nvarchar(50),
coulmn2 nvarchar(50),
coulmn3 nvarchar(50))
insert into tbl_Test (column1,coulmn2,coulmn3) values
('Griff','Serjey','Maciej'),
('King','Fisher','Ajay'),
('Paul','Griff','Serjey'),
('King','Fisher','Griff')
- Now, I'm going to search the value where the data is '
Griff
'. In the above table, there are 3 rows that contain 'Griff
'.
select *from tbl_test where 'Griff' IN (column1,coulmn2,coulmn3)
- 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