Can I strip a value from a serialized array in a select statement using mySQL?
Posted on 2014-08-03
I need to grab some data from a mysql database table in a quick query. Just something for the owner of the database to get a sum of some values.
For example, here is the serialized data -
And I need so sum values from qtyOne, qtyFive, qtyTwenty, qtyTotal, and total_amount for a date range (the date is in it's own field).
Can this be done or do I need to write a script to unserialize all values in the date range and add them up manually?