Sequel Pro is a great remote database management tool, when viewing contents of a table there is a basic filter option at the top of the view.
This is useful if your only after filtering a single value, if you wanted to filter against two more more columns you can't do that there.
In the past I've always used the query window and wrote out a query to do the filtering, doing is this way takes time it would be great if there was a simpler way to filter, turns out there is an advanced filter!
It's not obvious you can display it by going to the menu under Edit -> Find -> Find why on search it's called find I don't know! its a filter. A quicker way is using the keyboard shortcut command + F.
In the filter window all the table columns are displayed from there you only need to write a little sql to filter for instance say I wanted to display records for a specific date and name I can do this by only writing date1='2012-11-10' AND name='max_actions' and pressing Filter and volla done!
This is much quicker then writing a full query, much more useful.