mysql: how can i remove the street number from a streetaddress column? -

i have column named streetaddress contains

<street number> <street name> 

for example:

15 rue gontier-patin 4968 hillcrest circle 

how can remove numbers beginning of row purely in sql?

how - trim off , including first space in strings start number

update mytable  set addresscol=substring(addresscol, locate(' ', addresscol)+1) addresscol regexp '^[0-9]';