unserialize array in mysql field using just mysql?

[arianhojat]

Basically instead of having many columns in a table, when user saves data, i put user submitted data in a php serialized array in a mysql field for later reference.

Now I have to do a complex query where i want to do pretend ...

$field = serialized($row['data']);

$approved = $field['userapproved'];

...'WHERE userapproved='. $approved;

 

But id prefer to do it with a pure mysql query. Is this possible?

 

Id rather not do it with php logic like i have been doing, seems like ill be doing alot of checks when trying to build something like pagination in a search query.

[Barand]

try normalizing your data