gistfile1.txt

railsbot=# SELECT * FROM messages where TEXT ILIKE '%helpa has spoken%' ORDER BY created_at ASC;
   id    |            text            | channel_id | person_id |         created_at         |  type   | hidden
---------+----------------------------+------------+-----------+----------------------------+---------+--------
  707827 | HELPA HAS SPOKEN           |          2 |        62 | 2013-03-18 05:59:12.212002 |         | f
  856294 | HELPA HAS SPOKEN           |          2 |        62 | 2013-04-27 04:34:23.225048 | message | f
 1225891 | THE GREAT HELPA HAS SPOKEN |          2 |        62 | 2013-09-04 02:28:54.739519 | message | f
 1286350 | HELPA HAS SPOKEN           |          2 |        62 | 2013-09-25 00:27:29.322752 | message | f
 1329136 | HELPA HAS SPOKEN           |          2 |        62 | 2013-10-07 05:32:38.902049 | message | f
 1347391 | HELPA HAS SPOKEN           |          5 |        62 | 2013-10-11 05:27:00.39887  | message | f
 1463548 | HELPA HAS SPOKEN           |          2 |        62 | 2013-11-18 23:10:35.266593 | message | f
 1481557 | HELPA HAS SPOKEN           |          4 |        62 | 2013-11-23 23:23:15.305096 | message | t
 1669278 | HELPA HAS SPOKEN           |          2 |        62 | 2014-01-27 23:31:57.081289 | message | f
 1680334 | HELPA HAS SPOKEN           |          2 |        62 | 2014-01-31 00:41:45.476205 | message | f
 1834960 | HELPA HAS SPOKEN.          |          2 |        62 | 2014-03-05 22:00:30.485267 | message | f
 1867305 | HELPA HAS SPOKEN           |          2 |        62 | 2014-03-13 22:31:48.917919 | message | f
 1867360 | HELPA HAS SPOKEN           |          2 |        62 | 2014-03-13 22:39:29.183476 | message | f
 1876501 | HELPA HAS SPOKEN           |          2 |        62 | 2014-03-17 02:01:30.848338 | message | f
 1876515 | HELPA HAS SPOKEN (AGAIN)   |          2 |        62 | 2014-03-17 02:02:58.204976 | message | f