I have two tables in mysql, 'products' and 'categories'.
'products' -> column[categories] -- contains the category id.
'categories' -> column[id] -> column[name]
the categories column in 'products' lists the category ids in this format: |1|,|2|,|3|
The current query is getting the products from 'products' with an id as the identifier; ie: select stuff from products where id =5
I need someone to write function/query so the categories from the above query can be displayed by name.
|1| = category1
|2| = categories2
|3| = categories3
I need someone to write a function/query to get the name of that specific.