SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:01 AM
| ||||
| ||||
 using regexp in mysql to extract part of string Hi all, I would like to extract a part of a string stored in a varchar column in a mysql table. Since the part of string I want to extract is neither at a fixed position nor logically separated by a fixed character I was thinking using regexp would by a good idea Sample data: alf eats 2 cats peter's 50 cards apple ibook 2345 sold by apple computers scandlines mariner vessel 345 operated by Nordic Transport (all these are made up) What I want to extract is the part of string that is the part that comes before the first digit ... using perl i would : if ($string =~ /^(.*)\d+/) {$wanted = $1;} now my question : if testing in sql for : column1 regexp '([[:alpha:]]+)[[:digit:]]+([[:alpha:]]+)' how then can I extract / refer to the first subpattern ([[:alpha:]]+) ? What I would want is something like : select if ( column1 regexp '([[:alpha:]]+)[[:digit:]]+([[:alpha:]]+)'m $1, column1 ) Besides I m running Mysql 5.0.23 Any suggestios welcome TIA CVH      |
Linear Mode
