This is very useful. Can you please also show how this can be used to validate user input like for example:
We have this query currently: select id from users where id like '<user_enterred-value>%'; Now I want to validate that the user-enterred-value is only a numeric value... (the major problem is where users enter special characters that leads to exceptions / errors being thrown - like if the user enterred ' (a single quote) that would close the string and the %' would be considered as an invalid character..) Thanks - Anoop On 12/3/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > Possible solution is to use REGEXP: > > > > mysql> select '911' regexp '^[1-9]*$'; > > +-------------------------+ > > | '911' regexp '^[1-9]*$' | > > +-------------------------+ > > | 1 | > > +-------------------------+ > > > > mysql> select '91a1' regexp '^[1-9]*$'; > > +--------------------------+ > > | '91a1' regexp '^[1-9]*$' | > > +--------------------------+ > > | 0 | > > +--------------------------+ > > > > > > > > "C.R.Vegelin" <[EMAIL PROTECTED]> wrote: > > >Hi everybody, > > >I looked for a function to test whether a string is numeric (having > characters 0..9 only). > > >I found in the 5.0 manual Cast() and Convert(), but I don't think these > do what I need. > > >Any suggestion what function to use ? > > >Thanks in advance, Cor > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Thanks and best regards, Anoop