Help with Array Query

[foshizl]

ok, i have a mysql db and the table i have has multiple fields all are text except one which is for an array

 

my problem is Im trying to figure out how i can print the rows for only those who have a certain value in that field

 

the field in my table is called "category" it is an array and is serialized, so how would I display only the rows that in the category field match (whatever ie: dogs).

 

I hope someone can shed some light on this subject

[ranjuvs]

My understanding is that the array will be stored as a string. so you could use normal search query using "like" to search for a particular text.

 

SELECT * FROM table WHERE category like "%dog%;

[foshizl]

Thanks, I think that will work. going to have to make some changes to the way my DB stores into the array but in the long run it will be better