[rockfishroll]

I solved all of them. Minor nitpick: Since every criminal confesses to their crime, the fastest way to solve most of these is to query the confessions table for strings like '%i did%' or '%kill%'.

[chrisBHappy]

Haha. You found a cheat code I guess. I would have to think of hiding the answers from plain sight for the next cases or adding some more rows that include these specific strings.

[sprobertson]

That's how I solved #3, still trying to reverse-engineer the correct solution.

[dylan604]

Isn't that the reversed method? You mean you're now trying to solve the crime the normal way instead of jumping to the last page of the book first?