Re: Weekdays and BOOLEANs

[Felix Geerinckx]

NeoAmsterdam wrote:

> I had thought of that, but the combination of weekdays are 128. SETs can only hold 64 values.

Huh?

USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
wd SET('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat')
);

INSERT INTO foo (wd) VALUES
('Thu'),
('Mon,Wed,Thu'),
('Sat,Sun'),
('Mon,Thu');

SELECT id FROM foo WHERE FIND_IN_SET(DATE_FORMAT(CURRENT_DATE, '%a'),wd);

--
felix
Please use BBCode to format your messages in this forum.