Hi Brent, Lars, all !
While I cannot offer a solution, I still know the replace() approach
is incorrect:
Brent Baisley wrote:
The only regular expression MySQL support return a true/false if the
expression was found. I had to do something similar to what you want to
do. Although I needed
not to forget that there can also be street adresses like foobarstreet 23-25
or foobarstreet 17b and so on ... so i
guess i'll have to split my addresses into 2 fields from now on (street and
number). anyway thanks for ideas and
replies! best: lars
On 7/27/07, Joerg Bruehe [EMAIL PROTECTED]
Hi Lars,
Lars Schwarz wrote:
hi all, is there any shorthand to extract the string part of a varchar
field
only?
like when having german street addresses (e.g. foostreet 23) in a varchar
field
and i want to select the non-numeric part of it (foostreet) only?
I can't think of a way to do this
hi all, is there any shorthand to extract the string part of a varchar field
only?
like when having german street addresses (e.g. foostreet 23) in a varchar
field
and i want to select the non-numeric part of it (foostreet) only?
thanks, best: lars
The only regular expression MySQL support return a true/false if the
expression was found. I had to do something similar to what you want
to do. Although I needed to count how many digits there were.
You can use the REPLACE() function to strip out the numbers. Of
course, this means you need
hi all, i'm looking for a function to extract the string part of a varchar
field only. like when you stored an
street address in one field like foobar street 23 and i want everything
except the numeric value of it.
is it possible without a regexp? if not, anyone has a regexp for that
purpose
hi all, i'm looking for a function to extract the string part of a varchar
field only. like when you stored an street address in one field like foobar
street 23
and i want everything except the numeric value of it.
is it possible without a regexp? if not, anyone has a regexp for that
purpose