Need to know how to get only digit records

[EdLentz]

I have a DB that I had an ID field that has numerals and letters in some of the entries. I want to get ONLY the entries with the digits for the id entry. How can I do this?? Here is what I have so far

SELECT * FROM `sip` WHERE `keyword` LIKE 'secret' AND `id` like 102

This will pull the record 102. The id entries will be any digit up to a length of 6 digits long.

Can someone show me the way?

Thanks!

 

[ChrisHirst]

use a regular expression

Select ... ... REGEXP '[0-9]{n,x}' ... ...


n = min length x = max length so '[0-9]{3,10}' means a string of numerals min length 3, max length 10

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.

 

[EdLentz]

Thanks Chris that works perfectly!

Have a great weekend, mine just got better.