I have a string in a database which represents a range of key numbers.
The string looks like this:
The scheme is
Now I want to run a query that contains only one HSN and one TSN. Unfortunately I have no idea how to do this? The query would also have to consider e.g. 0600|920. Is there a SQL-Statement with which I can do this or do I have to rewrite the data before for example with PHP?
Many thanks in advance.
Source: Ask PHP