title: Is there a way to extract text matching a regular expression from a column in MySQL?
body: <p>For example, if all entries in a particular column have the form [a-z]+[0-9]+, how can one extract just the leading letters, so that asdf123 and as3456 return 'asdf' and 'as', respectively?</p>