michaelsanford
Translator, Web Developer
I have a database to store WiFi access points and I want to store, in a single column, the available protocols (b, g, a, e).
I've got my column set up as set('b', 'g', 'a', 'e') DEFAULT 'b','g'.
I'm slightly unsure about the way values are stored as a SET though (the MySQL documentation lists something about binary-encoded storage that confused me).
Will this let me do a select like SELECT FROM hotspots WHERE set='b'; if the column contains 'b', 'g', 'e' ? Will there be any other anomalous behaviour ?
I've got my column set up as set('b', 'g', 'a', 'e') DEFAULT 'b','g'.
I'm slightly unsure about the way values are stored as a SET though (the MySQL documentation lists something about binary-encoded storage that confused me).
Will this let me do a select like SELECT FROM hotspots WHERE set='b'; if the column contains 'b', 'g', 'e' ? Will there be any other anomalous behaviour ?