Hello,
I need to select some data from a table where a column is not a numerical value
but can't seem to get the right syntax for this.
Basically we need to do something like this:
SELECT * FROM tablename WHERE column_name (IS NOT A NUMERIC VALUE)
what is the correct syntax to accomplish
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
Thank you this is very helpful and was what I was looking for.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming Web Hosting Services
http://www.thunder-rain.com/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
DAC for MySQL is direct access components for MySQL, EnterpriseDB. It
allows you to create Delphi/C++Builder applications with direct access to
DAC for MySQL/EnterpriseDB without BDE and ODBC.
*What’s new in v2.9.5:*
Support for RAD Studio XE5 added, several minor improvements and bugfixes.
