Explore the archive

Search · 2014-08-01 to 2014-08-03

Find articles and conversations by date, subject or search expression.

search syntax

Search syntax

Type words or a Sphinx search expression in the query box. The plugin uses this expression for full-text matching through SphinxQL.

Start with a few words, then narrow the search using these examples, inspired by recent posts on The Standard.

All words
unemployment statistics

Find both words, anywhere in the indexed text. A space means AND; unemployment & statistics also works.

A phrase
"data centres"

Find these words next to each other, in this order. Use straight double quotes, as shown.

Either word
Labour | National

Find either word. Use the vertical bar for OR.

Leave a word out
election -Trump

Find election while excluding Trump. election !Trump also works. Include a positive search word; -Trump on its own is not a valid search.

Group alternatives
(Labour | National) unemployment

Find unemployment together with either Labour or National. Parentheses make combinations easier to read.

Words near each other
"coalition government"~5

Find these words close together, in either order, allowing fewer than five intervening words.

In a title
@title "data centres"

Find the phrase in a post or page title. Comments have no indexed title; select Posts for articles only.

In the body
@body "tactical voting"

Find the phrase in the text of a post, page or comment.

By an author
@author lprent @body search

Find search in the body of items whose indexed author name contains lprent. Use the displayed author or commenter name, which may differ from a login name.

In a category
@category politics

Match words in indexed category names. Use the Categories checkboxes to select a specific category and its descendants.

In a tag
@tags election

Match words in indexed tag names. Use the Tags checkboxes to select a specific tag. Comments inherit their parent post’s categories and tags.

Combine fields
@title election @body (Labour | National)

Require election in the title and either Labour or National in the body. A field applies to following words until another field or the end of its parenthesized group. @* switches back to all fields.

Which fields work with @?

The current index supports @title, @body, @author, @author_full, @category and @tags. @author_full lprent searches the same author text as @author lprent; it uses the same word-matching rules.

The date columns published_utc, calendar_day and date_added are numeric attributes used for filtering, date counts or ordering. They cannot be searched with @: expressions such as @published_utc 2026 or @calendar_day 20261107 produce a query error. Use the From and To (inclusive) controls for dates.

Likewise, use Content for posts, pages or comments, and the Categories and Tags checkboxes for specific terms. Their numeric IDs and content-type attributes cannot be searched with @.

For example, enter @title election, select Posts, set From to 2026-01-01 and To (inclusive) to 2026-11-07, then press Search. This combines the title search with an inclusive date range in the site’s time zone.

Find recent posts

Select Posts only and Newest first. In Text Search or Archive Explorer, set From to one year ago and To (inclusive) to today, then press Search. The sidebar opens Text Search, where you can add these dates. For comments, the date range uses the comment’s own date.

Try @title election, @title "data centres" or unemployment statistics. Recent starting points:

If the results surprise you

Check Content and the date, category and tag filters. English word endings may match the same stem, so quotes fix word order rather than spelling. Wildcard searches such as elect* require index settings that the plugin’s default configuration does not enable.

Enter the expression itself in the box; choose dates and ordering with the controls. For example, use Labour | National for alternatives.

Background: Search upgraded (yet again).

Content
Date range
Browse dates
Categories

Names open category archives. Check boxes to combine filters, including subcategories.

Browse all category archives

Tags

Popular tags and your selections. Names open tag archives; check boxes to combine filters.

Browse all tag archives

Clear all

Searching: posts Sorted by: newest Results: 1–14 of 14

Post

ACT’s voodoo economics

· mickysavage

Not satisfied with playing the Maori bashing card and appealing to some people's inherent racism ACT has released a further policy that will appeal to the right's greed. ACT has announced its policy on corporate tax and, surprise surprise, it wants to reduce it. Great…

act business capitalism

Post

Open mike 03/08/2014

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike ...

open mike

Post

The view from Russia

· Guest post

As some of you may realise, I (grumpy) cannot by any stretch of the imagination be described as a “leftie” and it may surprise your readers to know that I have been involved in International business for about 30 years and have many close friends…

International us politics

Post

Guest post – Gaza

· Guest post

This [showering a neighbour with rockets is an act of war, perpetrated by Palestine on Israel and Israel is quite entitled to take out the Hamas military apparatus] is a general argument I’ve often heard in the media, blogs, etc. over the past few weeks.…

war

Post

Open mike 02/08/2014

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike ...   lprent: I'm going to be doing some server changes later in the afternoon.

open mike

Post

NRT: Breach of contract

· notices and features

Reposted from No Right Turn. When National set up charter schools, they promised that they would be more accountable, and that contracts were a better means of enforcing standards than the usual school system. Only if they're enforced: “The Whangaruru contract online shows that the…

education national same old national schools

Post

Labour – Raise the minimum wage

· notices and features

Labour is promising to raise the minimum wage to $16.25. "But that will cost jobs!!!" is the usual right-wing response, and we hear it from some economists and most business interests. Other economists disagree, and they get much better support from the actual data, like…

employment jobs labour wages

Post

John Banks convicted

· mickysavage

In breaking news John Banks has not applied for a discharge without conviction and a conviction has been entered.  This is a realistic choice by him.  A discharge was never going to be given in a case like this. But he could have faced reality…

act corruption john banks Politics

Post

Open mike 01/08/2014

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike ...

open mike