Explore the archive

Search · 2010-10-01 to 2010-10-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–24 of 24

Post

Carter’s piss-poor blackmail & careerism

· Marty G

So, Chris Carter is threatening a 'tell-all' book on the Fifth Labour Government published at the next election. But he says he won't publish it if he gets to stay in Labour. It's blackmail, a further act of treachery for which he deserves to be…

accountability labour

Post

Be rad: vote Yani and James

· Eddie

OK, so it's quite up with the best campaign ad ever, but Yani Johanson and James Dann's anti-Bob Parker rap brought a smile to my face. Yani is running for councillor in the Hagley-Ferrymead ward and James is going for the Hagley-Ferrymead Community Board, both…

humour local body elections

Post

Big ups to Helen Kelly and a question for the lawyers out there

· IrishBill

CTU president Helen Kelly has managed to negotiate for a meeting between Peter Jackson and Actors Equity. This is great news and hopefully Kelly will help facilitate the meeting - she's got a solid record of being able to steer a sensible course through fraught…

employment

Post

India: Ignorance at a distance

· r0b

Tomorrow (1.30am our time) the Delhi Commonwealth Games opening ceremony will begin. Let's hope, for everyone's sake, that the Games proceed without incident. And good luck to all of our competitors. It's been pretty painful watching the media coverage of the Delhi games buildup over…

International Media sport

Post

ECE cuts hurt kids & parents

· Marty G

Early childhood education is great stuff. Those first few years shape a child's future more than any other. Getting into learning and into socialising early on leads to huge rewards later in life. For every dollar spent on ECE, society gets 13 back in benefits.…

education

Post

Open mike 03/10/2010

· notices and features

Open mike is your post. It's open for discussing topics of interest, making announcements, general discussion, whatever you choose. Comment on whatever takes your fancy. The usual good behaviour rules apply (see the link to Policy in the banner). Step right up to the mike...

open mike

Post

Some advice for Actors Equity

· IrishBill

It seems now that Peter Jackson is refusing to talk to Actors' Equity because it would affect the whole industry. Frankly it's starting to look like one excuse after another - a pattern of hit and run anti-negotiation tactics that anyone with experience in industrial…

Media Unions

Post

Ryall: Our Only Plan Is Cuts

· Bunji

Treasury in their first year under National tripled their expenditure on contractors.  Tony Ryall gave his reasoning behind this yesterday afternoon; coming up with that it was because National have so much more new policy than the previous government in its 'dying year'.  But then…

public services same old national

Post

Open mike 02/10/2010

· notices and features

Open mike is your post. It's open for discussing topics of interest, making announcements, general discussion, whatever you choose. Comment on whatever takes your fancy. The usual good behaviour rules apply (see the link to Policy in the banner). Step right up to the mike...

open mike

Post

Something odd in crime stats

· Marty G

The crime stats are not good news. Homicides are up, violent offences are up, sex offences are up, harassment and related offences are up, drug offences are up, public order offences are up. Oddly, though, the total number of offences is down (by 0.1%). The…

crime

Post

Without a trace of irony

· Marty G

Rodney Hide has taken a complaint to Parliamentary Services over Phil Twyford EA sending a message from his work email calling on people to vote for Len Brown "Hide said it was important that the democratic independence of local government was protected. "As such, individual…

accountability Parliament rodney hide scoundrels

Post

From Hounds to Foxes

· Guest post

Back in August I contributed a post entitled 'First they came'. The post discussed how, in education, teachers got bashed, then Principal's, then Boards. The post cautioned that as we watched and did nothing we edged closer to being bashed ourselves. Now I see that…

Unions wages

Post

A brief point on union meetings

· Eddie

There's a story doing the rounds today about the actors' union denying Peter Jackson entry to a union meeting. It's basically Jackson having a good old whine about how it just shows how unreasonable the union is being and how they won't even talk to…

Unions workers' rights

Post

Digested Read – Spirit Level 5: Sustainability

· Bunji

Digested Read Digested – Equality works better for a sustainable future. Equality does not equal sustainability, but it is much more suited to the task than our current system.  Without the constant need to consume more and more as we compete for status, we use…

equality sustainability

Post

Herald against Nats’ power grabs

· Eddie

The Herald's editorial today is a strong rebuke of National's anti-democratic power grabs: "Work has just begun for the 26 experts in constitutional law from all six of the country's law faculties who penned a letter condemning the Government's earthquake response legislation. No sooner was…

democracy under attack

Post

The tax cut fizzer

· Marty G

For a long, long time National and the Right have tried to convince us that all we really need is tax cuts. You can understand why: their other policies are deeply unpopular, cutting taxes is a roundabout way of cutting public services, which they hate,…

gst tax

Post

Open mike 01/10/2010

· notices and features

Open mike is your post. It's open for discussing topics of interest, making announcements, general discussion, whatever you choose. Comment on whatever takes your fancy. The usual good behaviour rules apply (see the link to Policy in the banner). Step right up to the mike...

open mike