Tools, Development

Use advanced filters in Sequel Pro

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.

David Carr

David Carr

For the past 12 years, I’ve been developing applications for the web using mostly PHP. I do this for a living and love what I do as every day there is something new and exciting to learn.

In my spare time, the web development community is a big part of my life. Whether managing online programming groups and blogs or attending a conference, I find keeping involved helps me stay up to date. This is also my chance to give back to the community that helped me get started, a place I am proud to be apart of.

Besides programming I love spending time with friends and family and can often be found together going out catching the latest movie, staying in playing games on the sofa or planning a trip to someplace I’ve never been before.