Database field contains value like "1,2,3,4,10"
Case 1
i would like to search the value "1,4"
Result needed is 1,4 is present 100%
Case 2
search the value "1,5"
Result needed is 1,5 is matching 50%
I am having one field stated "Value1"
Value1 Field must be multifield value. So it should allow multiple values in it.
I need to compare the value with another value and need to calculate the percentage calculations among them.
I want to use only PHP-MySQL for solving this problem.
Kindly...