RE: SELECT using IN on SET data

2001-08-10 Thread Don Read
On 10-Aug-2001 [EMAIL PROTECTED] wrote: > Hi, > > Whats the most efficient way of doing a SELECT ... IN on a field of > datatype 'SET' ? > > Say you have four types of 'permissions': >- superuser >- poweruser >- normal >- guest > > Each user has a field, permis

SELECT using IN on SET data

2001-08-09 Thread antiphobo
Hi, Whats the most efficient way of doing a SELECT ... IN on a field of datatype 'SET' ? Say you have four types of 'permissions': - superuser - poweruser - normal - guest Each user has a field, permissions, of type SET ("superuser","poweruser","normal","gue