Search string with range in database

  mysql, php, sql

I have a string in a database which represents a range of key numbers.
The string looks like this:

0600|914<>0600|930<>0603|300<>0603|308<>0603|430<>0603|438<>0603|517

The scheme is {HSN}|{TSN}

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.

H.

Source: Ask PHP

LEAVE A COMMENT