Query based on serialized array values

[biggieuk]

Hi all,

 

This may not be possible but I have serialized arrays in a table services, field related.

 

I am currently returning this array based on an id and unserializing the data. Another query then returns each title from the articles table where the ids corresponds to the unserialized array.

 

I am wondering if it's possible for me to query the articles table based on the serialzed array in the services table?

 

thanks for help with this.

 

 

[trq]

I am wondering if it's possible for me to query the articles  table based on the serialzed array in the services table?

 

Its likely possible, but it's not going to be pretty. It would have been much better to have stored your data in a proper normalized fashion instead of serializing the arrays in the first place.