RE: How to check if field has numeric data - jbon...@sola.com.au - com.mysql.lists.win32

2 messages in com.mysql.lists.win32RE: How to check if field has numeric...

From	Sent On	Attachments
James Frankman	11 Sep 2002 13:11
jbon...@sola.com.au	15 Sep 2002 15:59

Subject:	RE: How to check if field has numeric data
From:	jbon...@sola.com.au (jbon...@sola.com.au)
Date:	09/15/2002 03:59:36 PM
List:	com.mysql.lists.win32

Try using regexp

e.g. field regexp "^[0-9]*$"

John Bonnett

I there any sql function in mysql for checking if a field's value is a valid number? For instance if I have a varchar field, is there a function I can use to test if the value within this field is a valid number?