Black Friday sale is now on! 50% off Laravel: The Modular Way. Learn more

Use advanced filters in Sequel Pro

David Carr

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.

    Laravel Modules Book by David Carr

    Help support the blog so that I can continue creating new content!

    Subscribe to my newsletter

    Subscribe and get my books and product announcements.

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