Tools, Development

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 you're only after filtering a single value if you wanted to filter against two 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 it this way take 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 Table -> Advanced Filter Content. A quicker way is using the keyboard shortcut shift + 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 than writing a full query, much more useful.