I have a table with the following:
s_meta_value with the following array (an array within an array?):
The last value list of numbers are post ID's that I need use to select for the report. How do I go about extracting each of those ID's to use for the WHERE clause?
Unfortunately I didn't make/create the table, it's from a plugin otherwise I probably would not have serialized those ID's so they could be JOIN and searched.
I've tried SUBSTRING_INDEX but this doesn't work as the value is "40,268,18,319"