How to - LIKE - use prepared statements

I was going to do the whole Valley Girl theme for this post, but decided that was lame.
So while converting an internal application query into a user-input web query when I stumbled across a problem. My prepared statement was not throwing an error and not giving me results. It took me a while [...]