wicked thanks heaps this worked
select * from User where userID=3 AND FIND_IN_SET(34, site_access);
your a champ !
>>> Don Read <[EMAIL PROTECTED]> 03/24/03 03:02pm >>>
On 24-Mar-2003 Daniel Rossi wrote:
> hi there i have a field which i place comma delimitered id's like so
>
> 64,14,13,15
>
On 24-Mar-2003 Daniel Rossi wrote:
> hi there i have a field which i place comma delimitered id's like so
>
> 64,14,13,15
>
> these are site id's which i check against a user who has access, i also
> use it to check if to show a banner on a particular site, although
> further checking showed th
