A single field in a singel row. Right or wrong I didn't want to have a column for each theme, or medium etc. I implode the values from an array of checkboxes into a single string like the one above, 8, 28, 38, 48. I could go backan use the words labels instead of the ids and the LIKE might work better.
My goal was a lean database we are hoping for a lot of business. A lot of donations to non-profits.
Notice I added comma symbol after number "8". This will work except the last number, couse in your table you don't have comma at the end. So before you can use query above, first you need to update this field by adding one comma at the end.
I have a field which contains the following: 8, 28, 38, 48
How do I filter for just one number, for example 8?
Does not work!
Nick, what does not work? Are you getting all the rows that have %8% and you only want the row with the number 8? Are you getting an error, meaning your column is defined as a number and your LIKE statement will not work? We can sit here and throw all kinds of stuff out to you, but most will not be helpful.