Ed Reed wrote:
I hope someone can give me a suggestion on this.
I'd like to find records in a table where a specific field only contains a number.
For example,
Select Field1 as f
from table1 as t
where lcase(t.f) not like in
('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z')
This obviously doesn't work or I wouldn't be asking the question. In this example field1 is a varchar(25) field and it is normally appropriate for it to contain data that has numeric characters and alpha characters. Examples of valid data in this field are '456987','142154','200145C1','954xxx','H 1231','My Test', ......etc. In my query above I'm trying to find the records where there is only a six digit numeric value and no others.
Thanks for any advice
how about "^[0-9]+$"?
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
