From: Christopher Thompson
Date: August 21 2000 9:40pm
Subject: Fastest way to select sets
List-Archive: http://lists.mysql.com/mysql/48489
Message-Id: <002101c00bb8$787e3940$1700a8c0@elm>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

If I have a set with 10 items in it and I want to select a record if one or
more of the items are found, what is the fastest way to do this?

Is it better to create 10 TINYINT (or CHAR(0)?) fields and do "WHERE
field1=1 OR field3=1".

Or, is it faster to use the SET field type?

Or, some other way?