запись в бд:
id 1 = ||name2|value1,value2|name3=value3
id 3 = ||name2=value2,value3,value1||
SELECT id,
MATCH ( `field`) AGAINST ('+name2|value2' IN BOOLEAN MODE) as REL
FROM `table`
WHERE MATCH ( `field` ) AGAINST ('+name2|value2' IN BOOLEAN MODE)
ORDER BY REL DESC
Позиция искомого значения в строке не известна.