.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Original Message -
From: Sukhjinder K. Narula
To: Mike Blezien
Cc: MySQL List
Sent: Tuesday, October 08, 2013 8:08 AM
Subject: Re: Check for numeric values
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help you:
If your data is 'test', 'test0', 'test', '111test', '111'
SELECT * FROM myTable WHERE col1 REGEXP '^[0-9]+$';
Result: '111'
In regex ^ mean begin, and $ - end.
SELECT * FROM m