delimiter - Is there a way to modify the query result on MySQL? -

i have column returns pipeline delimited records below:

'fromstate=a|count=5|highlimit=b|status=c|presentvalue=d|alarmvalue=e'

is there way have more formatted output like:

'fromstate=a count=5 highlimit=b status=c presentvalue=d alarmvalue=e'

i.e.,

pipelines replaced and

each value on new line

Script