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.