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]> wrot
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
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 t
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 i
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
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 ha
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 ha
