使用split_part(string text, delimiter text2, field int)以字符为标识截取
其中:
-
- text 为截取字段
- text2 为截取标识符:按照什么形式切割(比如逗号’,’)
- int 为删除项目的位置:位置从1开始
举例:查询一个满足条件的灾害点图片
select image from geohazard_all_english where x = '110.31417' and y = '30.63582' and type = '地面沉降' and date = '201912'
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5iNxUDN3cTYwMjNiFWZ1U2YxYzXzQjNzkDMxMzLcJTMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
由图可知,查询结果有多个,且通过
,
分割,因此使用
split_part
select split_part(image,',',1) as image from geohazard_all_english where x = '110.31417' and y = '30.63582' and type = '地面沉降' and date = '201912'