使用MySQL中的所有列搜索多个值

I have store the serialized value in a column like

a:3:{i:0;s:6:"land_r";i:1;s:11:"mixed_use_r";i:2;s:3:"prs";}

Am going to search these columns with multiple values given from user like

residentialSelect[]=land_r&residentialSelect[]=mixed_use_r&residentialSelect[]=prs

I have to search this post value in all the column that contained serialized value.

The scenario: 1. New post save: The multiple select dropdown to store the serialized value in db first 2. Search post: The multiple select dropdown to search and show the respective post.

Please let me know if am not explained properly.