mysql显示第一个字符串_从MySQL中的第一个整数查找/剪切字符串

这个怎么样？？

SELECT

myWord,

SUBSTR(myWord,1,LEAST (

if (Locate('0',myWord) >0,Locate('0',myWord),999),

if (Locate('1',myWord) >0,Locate('1',myWord),999),

if (Locate('2',myWord) >0,Locate('2',myWord),999),

if (Locate('3',myWord) >0,Locate('3',myWord),999),

if (Locate('4',myWord) >0,Locate('4',myWord),999),

if (Locate('5',myWord) >0,Locate('5',myWord),999),

if (Locate('6',myWord) >0,Locate('6',myWord),999),

if (Locate('7',myWord) >0,Locate('7',myWord),999),

if (Locate('8',myWord) >0,Locate('8',myWord),999),

if (Locate('9',myWord) >0,Locate('9',myWord),999)

)-1) as NewString

FROM myTable;