Convert part of a string to int and do range comparison

[elsenorjose]

In my database there is a table that stores URLs. In the URL there is a string that identifies a specific port in the form of: '

http://blahdotcom/someotherstuff/somemorestuff?port:12345'

What I've been asked to do is identify ports that exist in certain ranges, for example between 1 and 100.

How would I extract just the numeric part of that string, convert it to int or other numeric so I can do a >=1 and <=100 query?

Thanks in advance.

 

[r937]

... where substring(url from 53)+0 between 1 and 100



r937.com | rudy.ca

 

[elsenorjose]

So that's assuming the string I want is always in the same position? (from 53?) And if it's not, is it a nightmare to modify?

 

[johnwm]

Use the INSTR function to find 'port:'

See

http://dev.mysql.com/doc/refman/4.1/en/string-functions.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[r937]

may i ask, is it always on the right, as the only thing on the right of the last colon? is port: the last url parameter?

if so, it's a lot easier

r937.com | rudy.ca

 

[elsenorjose]

Thank you both. I'll look at the instr function.

Rudy, port isn't the last parameter. I should have given a better example. You typically see additional values after that.