SQL: count occurences for each row : i have an SQL table called `Codes` with a column `code` of type String.
I also have another table called `Items` with a column `codestring` also of type String. This entry always contains a string with some of the codes of the above table seperated by spaces.
Now i want to get all codes and their number of Items containing the respective code. Can i do that?