Skip to content

Instantly share code, notes, and snippets.

Created May 30, 2014 20:41
Show Gist options
  • Save anonymous/814b4f8a7b8e8a52a381 to your computer and use it in GitHub Desktop.
Save anonymous/814b4f8a7b8e8a52a381 to your computer and use it in GitHub Desktop.
Serialized Data Blob Whittling technique. This one grabs the created date out of the ubercart order id.
SELECT
FROM_UNIXTIME(
SUBSTRING_INDEX(
SUBSTRING_INDEX(
SUBSTRING_INDEX(uo.data, 'created', -1),
';}', 1),
';i:', -1)
)
AS `Created Date`
FROM bitch_prod.uc_orders uo
WHERE uo.data LIKE '%created%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment