Product list module (BE) : Sql Condition for BLOB values ?

[chukaboy]

Hi everybody,

I'm wondering if it is possible to filter products with BLOB attribute (like a SELECT in my case) using SQL CONDITION FIELD in mod_iso_product list module BE ?

Thanks in advance.

Regards,

[Andreas]

No, you can't do this with SQL, I think it's a serealized string in your BLOB field. You have to do it on PHP level.

[chukaboy]

It is what I though after some search headaches =)
It's a shame for product listing : if a product have an attribute like SELECT (so a BLOB), we cannot use it to filter the listing ?

I hoped there was an allowed sql instruction like : FIND_IN_SET('value', deserialize(p1.attribute)) or something like that...