Mysql Row to Column with ';' separator
<p>i have a table (Catalogs) on my Mariadb 10.1</p>

<pre><code>id   value
1    one ; two ; one
2    two ; three ; one
3    four ; five
4    one
5    four ; one
</code></pre>

<p>how do i count and group the value on Catalogs table like on the table below.</p>

<pre><code> result    count
    one      5
    two      2
    three    1
    four     2
    five     1
</code></pre>

<p>or this table</p>

<pre><code>id value
1    one
1    two
1    one
2    two
2    three
2    one
3    four
3    five
4    one
5    four
5    one
</code></pre>