I do a lot of string functions to look at URLs. If I want to use a SUBSTRING and INSTR Function what's the best way to move the end a dynamic number of characters?
EXAMPLE: I want to show the string after the 1st '=' and before 'the_end' in the 'big_string' field.
I wrote:
SUBSTRING(`big_string`,INSTR(`big_string`,'=')+1,INSTR(`big_string`,'the-end')-INSTR(`big_string`,'='))
The above works but I'm getting an extra character at the end that preceeds 'the-end' that's different. I tried sticking -1 in a few different places and it broke. Thoughts?