Hi all,

I want to check if part of a field is numeric. For example, I have a field containing values such as

Anne
Anne-France
Annemary
Anne123

I want to find Anne123 by checking if the contents of the field past 'Anne' is numeric.

I currently have:

SELECT
max(username) as lastUsername
FROM
tbUser usr
WHERE
left(usr.username, len(username)) = username
and format(right(usr,username, char_length(usr.username) - len(username)) = cast(right(usr,username, char_length(usr.username) - len(username)) as unsigned)

where the italic text is simply a variable filled in with PHP.

... where username regexp "^Anne[[:digit:]]+"

or something like that