原来 字符 为
Abbeville (AL) USABB
trim(REVERSE(SUBSTRING(REVERSE('Abbeville (AL) USABB'),LOCATE(' ',REVERSE('Abbeville (AL) USABB') ),LENGTH('Abbeville (AL) USABB') ) ) )
//结果 为
Abbeville (AL)
原来 字符 为
Abbeville (AL) USABB
trim(REVERSE(SUBSTRING(REVERSE('Abbeville (AL) USABB'),LOCATE(' ',REVERSE('Abbeville (AL) USABB') ),LENGTH('Abbeville (AL) USABB') ) ) )
//结果 为
Abbeville (AL)
转载于:https://www.cnblogs.com/angdh/p/11275968.html