How to check if the data in the field is decimal using sql sysntax?

[Exequiel]

I have bunch of data in the table in my database, the field is in a varchar type, the field has deimal numbers, has integers, has letters etc. i only want to check if the data in that field is a decimal, how can i check that using only mysql syntax? no php.

Any comment are so apprecitaed, thank you. :)

[Rabbit]

Look for a dot in the string in addition to whether it's numeric.

[Exequiel]

@rabbit how can i code it into mysql?

[Rabbit]

You could use the regexp operator