ansaurus

Question

MySQL: Search range of strings with slash

Answer 1

+1 A:

What about using the substring_index function?

select substring_index(fieldname,'/',-1) as v from tablename where v between 1 and 5

Richard 2010-10-15 12:59:01

That works: select interface from test1 where substring_index(interface,'/',-1) between 1 and 5, but only if I am searching for the last numbers before the right most slash. Can't search for Gig1/1/11.

Rick 2010-10-15 13:10:45

...assuming I had more records like Gig1/1/10, Gig1/1/5... How would I search for those?

Rick 2010-10-15 13:12:02

perhaps using "select substring_index(fieldname,'/',-2) as v from tablename where v between '0/1' and '1/5'" as this would select 1/10,1/15 etc.

Richard 2010-10-15 13:26:06

ansaurus

tags:

views:

answers:

MySQL: Search range of strings with slash

related questions