is there any combination of 'in' and 'like' operator.

Question

string shape =  'round' ' pearl' 'oval' 'heart' 'princess' ; // first query - select * from table1 where shape in ( + shapes + ) // second query - select * from table1 where shape like '%Pear%'; now i want to use 'like' parameter for all other shape. in short how can i use combination of 'like' and 'in' operator. Thanks in advance.

Vulpes · Answer

Not sure what you mean by single or multiple selections. When I put the code I posted earlier into a program and run it: using System; using System.Text.RegularExpressions; class Program { static void Main() { string shape =  'round' 'pearl' 'oval' 'heart' 'princess' ; string temp = Regex.Replace(shape @\w+ %$0%); string[] shapes = Regex.Split(temp ); temp = shape like + String.Join( or shape like shapes); string query = select * from table1 where  + temp.Trim() + ;; Console.WriteLine(query); } } the output is: select * from table1 where shape like '%round%' or shape like '%pearl%' or shape like '%oval%' or shape like '%heart%' or shape like '%princess%'; which is what I thought you wanted here?

prince raj · Answer

Vulpes Please Help in http://www.c-sharpcorner.com/Forums/Thread/258515/two-string-in-where-condition-for-one-column.aspx Thanks

prince raj · Answer

Hello Vulpes  this work on single selection when more than two shape are selected its not return any row. ??????????

Vulpes · Answer

Sorry Bhabani but as someone who's principally a desktop developer it's not something which is within my areas of expertise.

Bhabani Prasad · Answer

can u help me vulpes http://www.c-sharpcorner.com/Forums/Thread/258307/

Vulpes · Answer

You just need to do a bit of manipulation to build the query from the raw 'shape' string: using System.Text.RegularExpressions; //..... string shape =  'round' 'pearl' 'oval' 'heart' 'princess' ; string temp = Regex.Replace(shape @\w+ %$0%); string[] shapes = Regex.Split(temp ); temp = shape like + String.Join( or shape like shapes); string query = select * from table1 where  + temp.Trim();

prince raj · Answer

Yes But i dont know how many and which shapes are in string. so how can i check like operator with all them ?

Vulpes · Answer

To the best of my knowledge there is no way that you can combine IN and LIKE in this way. All you can do is to use a series of ORs; select * from table1 where shape like '%round%' OR shape like '%pear%' OR shape like '%oval%' OR shape like '%heart%' OR shape like '%princess%';

prince raj · Answer

i want to use 'like' operator with all values in string. like '%round%' '% pearl%' '% oval%' '% heart%' '% princess%' ----------------------------- Thanks.

sudipta sanyal · Answer

string shapes =  'round' ' pearl' 'oval' 'heart' 'princess' ; string strQuery = select * from table1 where shape in ( + shapes + ); strQuery = strQuery +  Union all; strQuery = strQuery + select * from table1 where shape like '%Pear%' and shape in ( + shapes + );