TehQuila
Grünschnabel
Hi Leute
Ich suche eine Funktion für MySQL die genau das selbe (oder zumindest etwas ähnliches ) macht wie die Funktion "val()" in SQL.
Beschreibung der Funktion val()
In Access, the Val function accepts a string as input and returns the numbers found in that string.
The syntax for the Val function is:
Val ( string )
string is a string expression.
Note:
The Val function will stop reading the string once it encounters the first non-numeric character. This does not include spaces.
For example:
Val ("10 Main Street") would return 10
Val ("34 10 Main Street") would return 3410
Val (" 34 10 Main Street") would return 3410
Val (" 34 - 10 Main Street") would return 34
Val ("075") would return 75
Danke für eure Hilfe
Ich suche eine Funktion für MySQL die genau das selbe (oder zumindest etwas ähnliches ) macht wie die Funktion "val()" in SQL.
Beschreibung der Funktion val()
In Access, the Val function accepts a string as input and returns the numbers found in that string.
The syntax for the Val function is:
Val ( string )
string is a string expression.
Note:
The Val function will stop reading the string once it encounters the first non-numeric character. This does not include spaces.
For example:
Val ("10 Main Street") would return 10
Val ("34 10 Main Street") would return 3410
Val (" 34 10 Main Street") would return 3410
Val (" 34 - 10 Main Street") would return 34
Val ("075") would return 75
Danke für eure Hilfe