Like operator with comma separated values using SQL query

Question

I have not able to getting my data using like operation

below is my code

Declare @Search varchar(100)
set @Search='Gender,Name,Age'
select * from Table_SampleData where FieldName LIKE '%' +  @Search + '%'

I have my table data is like below

Table_SampleData

FieldName   Values
Gender       Male
Name         Mazhar
Age          31
Location     Hyderabad

My output should be

FieldName   Values
Gender       Male
Name         Mazhar
Age          31

Hellow this is not duplicate question, i use this query also WHERE (',' + RTRIM(MyColumn) + ',') LIKE '%,' + @search + ',%' but not working. — Mr doubt, Apr 02 '19 at 05:51
Dear that answr is not helping then how its duplicate. @Mureinik — Mr doubt, Apr 02 '19 at 06:00
Should be `where ',' + @Search + ',' LIKE '%,' + FieldName + ',%'` . Now do you see how complicates your solution be if you use this model ? — Squirrel, Apr 02 '19 at 06:00
Dear your answer is giving me correct output thank you, please update your answer i will mark as answer. @Squirrel — Mr doubt, Apr 02 '19 at 06:06
No worries. This thread is already closed. Can't post further answer — Squirrel, Apr 02 '19 at 06:07

score 0 · Answer 1 · answered Apr 02 '19 at 05:47

0

Like will try to find a string that contains the string 'Gender,Name,Age' as a whole.

Try using

where FieldName in('Gender','Name','Age')

answered Apr 02 '19 at 05:47

srworksalot

1 Answers1