MS SQL:
取“明”和“地”之间的:
select SUBSTRING(a.a, CHARINDEX('明', a.a)+1, CHARINDEX('地', a.a)-CHARINDEX('明', a.a)-1 )
from(
select '床前明月光疑是地上霜' as a
)a
包含“明”与“地”:
select SUBSTRING(a.a, CHARINDEX('明', a.a), CHARINDEX('地', a.a)-CHARINDEX('明', a.a)+1 )
from(
select '床前明月光疑是地上霜' as a
)a
取"地"之前的:
select SUBSTRING(a.a, 1, CHARINDEX('地', a.a)-1 )
from(
select '床前明月光疑是地上霜' as a
)a
温馨提示:内容为网友见解,仅供参考