1st August 2008 at 11:44 am #17545
As you found yourself, Summer is deleted, but summer isn’t.
Case sensitivity is the problem.
A simple and common solution is casting both values to lowercase, then compare them:
… AND LOWER(songs.title) like “%summer%” AND …