I have set up a page with the following MySQL query:

SELECT cd_id, cd_number, cd_title FROM cds WHERE cd_title LIKE '%$search%' ORDER BY cd_number ASC

This finds some of the search terms that are there to be found, but others it does not find. Can anyone tell me why please?