Skip to content

Instantly share code, notes, and snippets.

View tsmango's full-sized avatar

Tom Mango tsmango

34 followers · 0 following
View GitHub Profile
@tsmango
tsmango / gist:1165379
Created August 23, 2011 15:09
SELECT * FROM comments
WHERE thread_id LIKE BINARY '2A'
OR thread_id LIKE BINARY '2B'
OR thread_id LIKE BINARY '2C';
@tsmango
tsmango / gist:1165377
Created August 23, 2011 15:08
SELECT * FROM comments WHERE thread_id IN ('2A', '2B', '2C');
@tsmango
tsmango / gist:1165376
Created August 23, 2011 15:08
SELECT * FROM comments WHERE thread_id LIKE BINARY '2A';
@tsmango
tsmango / gist:1165375
Created August 23, 2011 15:08
SELECT * FROM comments WHERE thread_id = '2A';
@tsmango
tsmango / gist:1165366
Created August 23, 2011 15:04
(SELECT * FROM `users` WHERE (name = 'tom')) UNION (SELECT * FROM `users` WHERE (name = 'gary')) ORDER BY created_at;
@tsmango
tsmango / gist:1165363
Created August 23, 2011 15:04
User.union([{:conditions => ['name = ?', 'tom']}, {:conditions => ['name = ?', 'gary']}], {:order => 'created_at'})
@tsmango
tsmango / gist:1165362
Created August 23, 2011 15:03
ActiveRecord::Base.union(parts, options = {})
@tsmango
tsmango / gist:1165358
Created August 23, 2011 15:01
total 1133325 docs, 266596694 bytes
total 117.702 sec, 2265011.00 bytes/sec, 9628.75 docs/sec
@tsmango
tsmango / gist:1165348
Created August 23, 2011 14:59
xml.media(:content, :url => "some-image-url", :type => "image/jpeg")
@tsmango
tsmango / gist:1165347
Created August 23, 2011 14:58
xml.rss(:version => "2.0", "xmlns:media" => 'http://search.yahoo.com/mrss/')