MySQL Forums
Forum List  »  Microsoft SQL Server

Re: IsNumeric() clause in MySQL??
Posted by: Henri-Maxime Ducoulombier
Date: April 14, 2005 06:29AM

I personnaly would suggest using a regular expression.

Here is a very basic one, but you could enhance it to make the numeric format you want to match :

SELECT * FROM myTable WHERE myField REGEXP ('[0-9]')

Cheers

Options: ReplyQuote


Subject
Written By
Posted
September 10, 2004 12:08PM
September 16, 2004 10:31PM
Re: IsNumeric() clause in MySQL??
April 14, 2005 06:29AM
November 24, 2008 04:43PM
January 07, 2009 11:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.