Export stats from mysql field

Question

I have a mysql field which has a varchar value with the following format:

option-value, option-value, option-value

Here are 2 example tuple values:

"desk-4, table-2, bed-5"
"desk-2, bed-3, table-8, mattress-10"

I want to have a php-mysql query which can match and calculate (sum) the same products with their values from mutiple records, so that the result would be:

desk 6
table 10
bed 8
mattress 10

Improved question format. – GramThanos Mar 21 '17 at 12:14 — GramThanos, Mar 21 '17 at 12:14

score 0 · Answer 1 · edited May 23 '17 at 12:25

0

You could just add this function to split a string in MySQL: https://stackoverflow.com/a/2696901/6441091

Then use SUM() and GROUP BY on the result.

edited May 23 '17 at 12:25

Community

1
1

answered Mar 21 '17 at 08:14

remborg

528
3
14

Export stats from mysql field

1 Answers1