mySQL syntax help for a query
Posted on 2014-04-09
I have lots of text in a column (mediumtext) with lots of rows. I need to find the position of a substring like:
- the string is always that length, 17 bytes
- it always includes a colon in the 9th position
- each of the 16 other characters are a 0 to 9 or A to F (i.e. a HEX)
- it won't have a /n or /t or any other special characters in it
Can I do this with a single query or is there an efficient way to do that with a function?