You can use regular expressions in mysql to check for the right format,
but (as far as i know) you can not return any matches: SELECT * FROM
table WHERE column REGEX '[0-9]+';, which returns all records where
column has a digit in its value.
In PHP however, you can easily get the matches:
Hi all,
It's really frustrating, I got a problem to trim a string using MySQL's
function.
The fact is that I want to rtrim a number from a string, that is:
if the string is abc2321413412, I want the function to return 2321413412;
c123,