Hi
I have a colum that contains semicolon separeted lists
eg.:
|related_content
|1;34;5;4
I want do a select ala:
SELECT * FROM catalogue WHERE relatedContent LIKE '%5%'
The query above will offcourse work to some point, but if the colum contains eg. "4;55;2" this will also return set/s (55)
How can I do the query so I find only the rows which have "5" in related_content?