开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜