· 8 years ago · May 18, 2018, 01:28 PM
1CREATE TABLE IF NOT EXISTS `foo` (
2 `a` int(11) NOT NULL,
3 `b` varchar(50) NOT NULL
4) ENGINE=MyISAM DEFAULT CHARSET=latin1;
5
6INSERT INTO `foo` (`a`, `b`) VALUES
7(2345345, 'title and volume'),
8(145344, 'Volume'),
9(1234214, 'Title');
10
11SELECT * FROM `foo` WHERE MATCH (a,b) AGAINST ('title' IN BOOLEAN MODE)
12
13SELECT *
14FROM `foo`
15WHERE MATCH(`a`) AGAINST ('title' IN BOOLEAN MODE)
16OR MATCH(`b`) AGAINST ('title' IN BOOLEAN MODE)