Hi,
I have a table with a field that will have values as follows:
"Value1, Value2, Value 3, Value 4"
"Value2, Value1, Value 6"
"Value 3, Value 4, Value, 5, Value 1"
Basically same set of words repeated in random order.
Search Scenario I : search string "Value1, Value2" should return 1st and 2nd row.
Search Scenario II : "Value 2, Value1" should also return 1st and 2nd row.
Search Scenario III : search string "Value1, Value3" should return 3rd row.
Now I am not sure how to write the SQL for this.
Any insight would be really great.
Thank you very much.
I have a table with a field that will have values as follows:
"Value1, Value2, Value 3, Value 4"
"Value2, Value1, Value 6"
"Value 3, Value 4, Value, 5, Value 1"
Basically same set of words repeated in random order.
Search Scenario I : search string "Value1, Value2" should return 1st and 2nd row.
Search Scenario II : "Value 2, Value1" should also return 1st and 2nd row.
Search Scenario III : search string "Value1, Value3" should return 3rd row.
Now I am not sure how to write the SQL for this.
Any insight would be really great.
Thank you very much.