You are here: Home » Reply

Reply To: Deleting Playlist Entries via sql

#17545

EVILRipper
Participant

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 …