How to make a selection from a Mysql table by a value in a field other than numbers?

Question

MySQL

Greetings!
Please tell me mysql.
There is a `chanel`( VARCHAR) field of the record which can be numeric 123345 or 'test_chanel' or string literal.
Forgive me if the wording is incorrect)
Is it possible using Mysql in the WHERE clause to somehow make a selection exactly where it is not equal to a number.
The database is relatively large and I don’t want to sort it out using php.
Thanks for the answer.

Answer 1

www.sqlfiddle.com/#!9/4d39ea/1/0

select * from users 
where value NOT REGEXP "-?^[0-9]*.?[0-9]*$"