I could really use some help ...
I am trying to conditionally select data from a table (ie select * from database where variable like/= etc) ...
is there a way to combine the like and in statements ...
I want to use a "where variable in (data1, data2, data3, etc.) and use wildcards for the entrys ... (ie like '%data1%')
Is this possible?? the alternative is to keep repeating the "where variable like '%data1%' or variable like '%data2%' or ... " I use a whole pile of these and this takes way too long :(
I would appreciate any help!!!
I am trying to conditionally select data from a table (ie select * from database where variable like/= etc) ...
is there a way to combine the like and in statements ...
I want to use a "where variable in (data1, data2, data3, etc.) and use wildcards for the entrys ... (ie like '%data1%')
Is this possible?? the alternative is to keep repeating the "where variable like '%data1%' or variable like '%data2%' or ... " I use a whole pile of these and this takes way too long :(
I would appreciate any help!!!