How to split text in column into 2 columns (MYSQL) after separator
I am looking for some code, which can do separated text from column description into columns test 1 and test 2
Example
description (pri开发者_如何学运维ce $250, New York, Beautiful house)
What I need
test 1 $250
test2 New York
I think you are searching for the explode()
function.
精彩评论