Skip to content

Instantly share code, notes, and snippets.

@dyangrev
Created March 6, 2015 22:39
Show Gist options
  • Select an option

  • Save dyangrev/64d3297decb28bb943f5 to your computer and use it in GitHub Desktop.

Select an option

Save dyangrev/64d3297decb28bb943f5 to your computer and use it in GitHub Desktop.
mysql> select * from GuestStayInfo where value like '%[{%' order by created_at desc limit 1;
+--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | guest_stay_id | user_id | action_type | created_by | created_at | attribute_name | value |
+--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 888393 | 4446304 | NULL | add | NULL | 2015-03-06 22:35:16 | notes | {"value":"[{\"value\":\"gtd csp @ 314.50 - gtd csp @ 314.50\",\"date\":\"2015-02-10T14:51:42.000-0500\"}]","guestStayId":4446304,"createdAt":"2015-03-06T22:35:16+00:00"} |
+--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment