String matching /comparing with another set of string with different **combination** in Mysql 5.0/C#/LINQ

Vote count:

0

I have some strings, for example:

string 1 : I want to see my friend

string 2: My friend has a red pen and yellow box

string 3: This yellow car belongs to my friend

string 4: He is a doctor

etc....

I want to compare these strings with another string : pen box friend and should get result at first string2, then string 3 and then string1

please help me. I want to know how it should be done. The way I am thinking is a very time consuming method.Is there any simple method to do so whatever be the logic. I want it to done in any of the following: Mysql5.0 or C# or LINQ

asked 34 secs ago

ansari tk

1

String matching /comparing with another set of string with different **combination** in Mysql 5.0/C#/LINQ