Hi, my name is David Carr and I'm a PHP Developer.


Blog Archives Categories Authors About Me Open Source Books Contact Me

Sponsor Me

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

My Latest Book

Laravel: The Modular way

Learn how to build modular applications with Laravel Find out more

Use advanced filters in Sequel Pro

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.

Copyright © 2009 - 2022 David Carr. All code MIT license. All rights reserved.