Tools | Development

David Carr

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.

Domains are often purchased from multiple providers, keeping track of where a domain is and its DNS settings can be tricky. Domain Mapper solves this by listing all your domains in one place. View your DNS settings and receive reminders to renew your domains. Try it today.

Support my work by donating with PayPal.

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2009 - 2021 DC Blog. All code MIT license. All rights reserved.