On Tuesday 07 September 2004 12:14, rolando g wrote:
> 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
> record...
> 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

You're not using the database properly. Have a separate table where each 
record contains a user_id and the record_id to which it is linked.

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Search the list archives before you post
        Life is *not* a Cabaret, and stop calling me chum!

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

Reply via email to