Proper LIKE Comparison For MySQL and UUIDs

I recently ran into this issue, and I wasn’t able to find any meaningful information online until I posted on StackOverflow about it, so I’m hoping that this will help someone else in the future.  In an application I’m developing, UUIDv4’s are being used to load up a form from the database to dynamically display to the end-user to fill out.  The hex representation of a UUID is 32 characters long (excluding dashes), and this would simply be too cumbersome to ask an end-user to enter if they needed to manually navigate to a form.  Therefore I decided to use a LIKE comparison, allowing the user to specify the UUID in the URL in 1 byte increments (2 hex characters). Continue Reading…