Using array functions on mysql field

Question

I have a little strange question on MySql. I have table named adds and that table has places field where are stored places id. Places field value equals serialized array (e.t.c array('1', '3', '4')) of places ids'. Also i have search form and I would like to search more fields than one at once. For ex: I would like find places with ID('3', '6', '8' and so on). When i query using mysql like this it throws an error.

$val=array('3', '6', '8');
mysql_query("Select * from add where active='active' && array_intersect(unserialize(places))");

How can i do query? May it possible using stored procedures or functions in MySql?

score 0 · Accepted Answer · edited May 23 '17 at 10:33

0

You should use implode to turn it into a usable string. This assumes your array of values is completely trustworthy (i.e. not from a user submitted form)

$val=array('3', '6', '8');
mysql_query("Select * from add where active='active' AND ID IN (" . implode(',', $val) . ")";

Please be aware that mysql_ functions have been removed from PHP

edited May 23 '17 at 10:33

Community

1
1

answered Apr 27 '16 at 03:39

Machavity

30,841
27
92
100

No, what i want isn't that. Here the value of ID is serialized array. Suppose that id isn't single number, here ID is serialized array. I must choose if some of $val array indexes exists in ID – Azer Qurbanov Apr 27 '16 at 05:19
Thank you very much – Azer Qurbanov Jun 19 '16 at 13:57

Using array functions on mysql field

1 Answers1