I am storing array of user IDs as TEXT using the serialize() function
on the array, since several users, one or none can be part of each

and I noticed that the serialized array has the values in double
quotes  like :"21";  for example... so since I know that the values
will be enclosed,  i am using the sql statement, with 21 as the
example variable:

SELECT FROM table WHERE userarray LIKE '%\"21\"%'

is there a better way or a built-in mySQL function to filter through
the serialized array

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to