Sequel Pro Content Filters

gistfile1.js

{
	number = (
		{
			MenuLabel = "=";
			NumberOfArguments = 1;
			Clause = "= '${}'";
		},
		{
			MenuLabel = "\U2260";
			NumberOfArguments = 1;
			Clause = "!= '${}'";
		},
		{
			MenuLabel = ">";
			NumberOfArguments = 1;
			Clause = "> '${}'";
		},
		{
			MenuLabel = "<";
			NumberOfArguments = 1;
			Clause = "< '${}'";
		},
		{
			MenuLabel = "\U2265";
			NumberOfArguments = 1;
			Clause = ">= '${}'";
		},
		{
			MenuLabel = "\U2264";
			NumberOfArguments = 1;
			Clause = "<= '${}'";
		},
		{
			MenuLabel = IN;
			NumberOfArguments = 1;
			Clause = "IN (${})";
		},
		{
			MenuLabel = LIKE;
			NumberOfArguments = 1;
			Clause = "LIKE '${}'";
		},
		{
			MenuLabel = BETWEEN;
			NumberOfArguments = 2;
			ConjunctionLabels = (
				AND,
			);
			Clause = "BETWEEN '${}' AND '${}'";
		},
		{
			MenuLabel = "IS NULL";
			NumberOfArguments = 0;
			Clause = "IS NULL";
		},
		{
			MenuLabel = "IS NOT NULL";
			NumberOfArguments = 0;
			Clause = "IS NOT NULL";
		},
	);
	string = (
		{
			MenuLabel = "=";
			NumberOfArguments = 1;
			Clause = "= $BINARY '${}'";
		},
		{
			MenuLabel = "\U2260";
			NumberOfArguments = 1;
			Clause = "!= $BINARY '${}'";
		},
		{
			MenuLabel = LIKE;
			NumberOfArguments = 1;
			Clause = "LIKE $BINARY '${}'";
		},
		{
			MenuLabel = "NOT LIKE";
			NumberOfArguments = 1;
			Clause = "NOT LIKE $BINARY '${}'";
		},
		{
			MenuLabel = contains;
			NumberOfArguments = 1;
			Clause = "LIKE $BINARY '%${}%'";
		},
		{
			MenuLabel = "does not contain";
			NumberOfArguments = 1;
			Clause = "NOT LIKE $BINARY '%${}%'";
		},
		{
			MenuLabel = "matches RegExp";
			NumberOfArguments = 1;
			Clause = "REGEXP $BINARY '${}'";
		},
		{
			MenuLabel = "does not match RegExp";
			NumberOfArguments = 1;
			Clause = "NOT REGEXP $BINARY '${}'";
		},
		{
			MenuLabel = IN;
			NumberOfArguments = 1;
			Clause = "IN (${})";
			Tooltip = "IN ([arg])\n\nDo quote strings manually.";
		},
		{
			MenuLabel = BETWEEN;
			NumberOfArguments = 2;
			ConjunctionLabels = (
				AND,
			);
			Clause = "BETWEEN $BINARY '${}' AND '${}'";
		},
		{
			MenuLabel = "IS NULL";
			NumberOfArguments = 0;
			Clause = "IS NULL";
		},
		{
			MenuLabel = "IS NOT NULL";
			NumberOfArguments = 0;
			Clause = "IS NOT NULL";
		},
		{
			MenuLabel = "is empty";
			NumberOfArguments = 0;
			Clause = "LIKE ''";
		},
		{
			MenuLabel = "is not empty";
			NumberOfArguments = 0;
			Clause = "NOT LIKE ''";
		},
	);
	date = (
		{
			MenuLabel = "=";
			NumberOfArguments = 1;
			Clause = "= '${}'";
		},
		{
			MenuLabel = "\U2260";
			NumberOfArguments = 1;
			Clause = "!= '${}'";
		},
		{
			MenuLabel = "is after";
			NumberOfArguments = 1;
			Clause = "> '${}'";
		},
		{
			MenuLabel = "is before";
			NumberOfArguments = 1;
			Clause = "< '${}'";
		},
		{
			MenuLabel = "is after or equal to";
			NumberOfArguments = 1;
			Clause = ">= '${}'";
		},
		{
			MenuLabel = "is before or equal to";
			NumberOfArguments = 1;
			Clause = "<= '${}'";
		},
		{
			MenuLabel = BETWEEN;
			NumberOfArguments = 2;
			ConjunctionLabels = (
				AND,
			);
			Clause = "BETWEEN '${}' AND '${}'";
		},
		{
			MenuLabel = "IS NULL";
			NumberOfArguments = 0;
			Clause = "IS NULL";
		},
		{
			MenuLabel = "IS NOT NULL";
			NumberOfArguments = 0;
			Clause = "IS NOT NULL";
		},
	);
	spatial = (
		{
			MenuLabel = contains;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBRContains(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = within;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBRWithin(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = disjoint;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBRDisjoint(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = equal;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBREqual(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = intersects;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBRIntersects(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = overlaps;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBROverlaps(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = touches;
			NumberOfArguments = 1;
			"SuppressLeadingFieldPlaceholder" = YES;
			Clause = "MBRTouches(GeomFromText('${}'),$CURRENT_FIELD)";
		},
		{
			MenuLabel = "IS NULL";
			NumberOfArguments = 0;
			Clause = "IS NULL";
		},
		{
			MenuLabel = "IS NOT NULL";
			NumberOfArguments = 0;
			Clause = "IS NOT NULL";
		},
	);
}