在SELECT中将一列值分成两列? [英] Split a column value into two columns in a SELECT?
本文介绍了在SELECT中将一列值分成两列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在varchar列中有一个字符串值。它是一个包含两部分的字符串。
I have a string value in a varchar column. It is a string that has two parts. Splitting it before it hits the database is not an option.
该列的值如下所示:
one_column:
'part1 part2'
'part1 part2'
所以我想要的是一个看起来像这样的结果集:
So what I want is a a result set that looks like:
col1,col2:
part1,part2
part1,part2
如何在SELECT语句中执行此操作?我找到了一个pgsql函数,将字符串分割成一个数组,但是我不知道如何将其分成两列。
How can I do this in a SELECT statement? I found a pgsql function to split the string into an array but I do not know how to get it into two columns.
推荐答案
select split_part(one_column, ' ', 1) AS part1,
split_part(one_column, ' ', 2) AS part2 ...
这篇关于在SELECT中将一列值分成两列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文