select non alphabet string

[enterume]

Hi,

Is there any mysql function which I can use to select only if the string is other than alphabet, in condition?

What i trying to do is :

Select * from mytable where field1 NOT like alphabet..

Any idea?
😕

[enterume]

I got the answer myself...

REGEXP "^[0-9]{1,}$"

this REGEXP in MySQL is freshy to me. 🆒

[jsim]

I'm don't want to disappoint you, but there is no special MySQL function to do that (as far as I know).
But you can try FIND_IN_SET function - maybe it solves your problem (if I get it right)

[LordShryku]

MySQL has Regex, just like he said. That regex would work just fine.

[jsim]

i know that. i know. i KNOW this! 🙂
Well, it a right time to get some rest 🙂