I am wondering how I can write a stored procedure that returns strings based on category keywords. The example search below returns the categoryID of the last category in the list and the whole string. Below are 3 examples.
The results should look like this.
"Causes / International / Cancer", ACD502
"Art / International / Painting", ACD536
"Countries / International", ACD 5363
SELECT name FROM Categories
WHERE Name LIKE "Interational"
Categories Table Columns
Thanks in advance.