So I run multiple pastebin services. One day, a friend needed a paste from weeks ago and so to the database I went (using stikked). I needed to search the paste content, known as column “*raw*” and pull out the record corresponding to the content (date, id, etc..).

What’s awesome is you can use regex in all of your sql statements when searching anywhere in the db. So I just did this:

SELECT * FROM `pastes` where raw REGEXP 'text_to_find';

BOOM, got results:) Thanks internet.

Mario Loria is a builder of diverse infrastructure with modern workloads on both bare-metal and cloud platforms. He's traversed roles in system administration, network engineering, and DevOps. You can learn more about him here.