Here is the data from an Export. It goes id, number, cd_title, date inserted and date updated. There is more, but this makes the point:
INSERT INTO cds
VALUES (1, ‘201’, ‘Cambridge Singers a cappella, directed by John Rutter’, ‘2010-01-27 11:07:57’, ‘0000-00-00 00:00:00’);
INSERT INTO cds
VALUES (2, ‘202’, ‘This Joyous Night, Music for Christmas, Cavendish Singers and Ensemble, Mavinder Ratten’, ‘2010-01-26 12:28:21’, ‘0000-00-00 00:00:00’);
INSERT INTO cds
VALUES (3, ‘204’, ‘The Tallis Scholars sing Thomas Tallis - disc 2’, ‘2010-01-24 00:00:00’, ‘0000-00-00 00:00:00’);
INSERT INTO cds
VALUES (7, ‘301’, ‘BOITO Mephistopheles Disc 1’, ‘2010-01-25 17:30:24’, ‘0000-00-00 00:00:00’);
INSERT INTO cds
VALUES (8, ‘302’, ‘BOITO Mephistopheles Disc 2’, ‘2010-01-27 11:20:00’, ‘2010-01-27 12:36:34’);
INSERT INTO cds
VALUES (9, ‘303’, ‘BOITO Mephistopheles Disc 3’, ‘2010-01-25 17:49:00’, ‘0000-00-00 00:00:00’);
In the first row, when I ask it to find ‘Singers’ it does it just like that, but it says that ‘Cambridge’ is nowhere to be found. It can find Sing and Si as well but not Cam.
This is a home job, but it is useful practice and it would be a useful index to my CDs if only it would work.
I would be grateful to be told that this certainly should not happen, if that is the case.