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 thi
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
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.
*Full
