You can store a PHP array in MySQL using the serialize () and unserialize () functions. serialize () converts any data, including arrays, to a string that can be converted back to its original value using unserialize ().
I am sure that other languages have similar capabilities and methods.
The only thing you cannot parse and search with pure SQL.
source
share