· 6 years ago · Mar 21, 2019, 12:18 AM
1CREATE TABLE IF NOT EXISTS `names` (
2 `ID` int(6) unsigned NOT NULL,
3 `C1` varchar(200),
4 `C2` varchar(200),
5 `C3` varchar(200),
6 PRIMARY KEY (`id`)
7) DEFAULT CHARSET=utf8;
8INSERT INTO `names` (`ID`, `C1`, `C2`, `C3`) VALUES
9 ('1', 'Richard', 'Ken', 'Dan'),
10 ('2', NULL,'Richard', 'Helen'),
11 ('3', 'Ken', NULL, 'Maria');
12
13SELECT *
14FROM `names`
15WHERE C1 = 'Ken' or C2 = 'Ken' or C3 = 'Ken'