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 that say i did a select * from table where sites_access IN (4) it will still pick up the 4 in both 64 and 14 , is there are way to get an exact match of 4 ? so it would return true if i had it like this 64,14,13,15,4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]