Explore the archive

Search · 2010-11-29 to 2010-11-30

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–13 of 13

Post

Open democracy?

· Marty G

There used to be a webcam in the Beehive Theatrette run by R2 that broadcast the PM's Post-Cabinet press conference. Anyone who wanted to could go to the site and watch the press conference live and uncut. It was direct access for the public, the…

democratic participation Media

Post

Labour’s Brotherly Dynamic Duo

· Michael Foxglove

They've already been dubbed NZ's David and Ed Milliband. Brothers David and Ben Clark will both be standing for Labour in the 2011 general election. David is standing for the safe Dunedin North seat, while Ben will be taking on Wayne Mapp on the North…

election 2011

Post

Prizes! Tickets to Gagarin Way

· notices and features

You may have seen ads on the site recently for a comedy play called Gagarin Way, which opens in Auckland this Wednesday. As part of the Scoop ad cartel, we have four pairs of tickets to give away. Here's the game: best - ie most…

culture humour

Post

Leaked cables window into Superpower

· r0b

Wikileaks' latest coup is the release of a database of more than 250,000 diplomatic cables between American embassies, up to and including the highest security level "Top Secret". The material was first released to selected newspapers, The Guardian, Der Spiegel, Le Monde, El País, and…

helen clark john key us politics war

Post

Trans-Tasman: Key the smile & wave PM

· Eddie

In the annual Trans-Tasman 'roll-call', amongst the normal love-struck schoolboy prose that we expect from the Trans-Tasman when referring to any National leader, is this judgment on the PM: "Key needs an agenda, not just the consensus he is building around personal trust." In other…

john key Media

Post

Open mike 30/11/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

Unconscionable

· Bill

A couple of comments by one of the commentators on the Standard stuck in my mind. Jenny drew attention to the fact that the Commissioner for the Environment had pulled the "Lignite and Climate Change: The High Cost of Low Grade Coal" report that was…

capitalism climate change Economy energy Environment

Post

Don who?

· r0b

So, I was going to do a post about Don Brash's latest Orewa blurt. Looking round at the headlines it has all the right ingredients for a nice juicy post: Brash attacks Maori - again Brash takes aim at Key in race speech Don Brash’s…

Maori Issues national racism

Post

New Left Party coming, or is it?

· Eddie

Matt McCarten is doing the dance of the seven veils on the issue of a new Left Party. He and the other players have been denying they have anything planned but, at the same time, have spoken of the need for such a party, as…

election 2011 Left

Post

Sickening attempts at political-point scoring

· Marty G

It's dismaying to see a few rightwing commentators using the Pike River disaster to attack restrictions on mining in national parks. The claims are baseless and crassly opportunistic. One expects the like of Matthew Hooton, Whaleoil, and Paul Holmes to try to score political points off…

Mining scoundrels

Post

Gaynor on something important

· lprent

After the shallowness of the MSM this week, I noticed an important issue being raised by Brian Gaynor. The question of "Crisis of accounting's double standards". This is a problem that has both an immediate and long-term concern for the confidence of investors  in New…

business Economy

Post

Cunliffe’s bad politics

· IrishBill

I was immensely disappointed by David Cunliffe's recent announcement that Labour is considering private public partnerships. Not only because PPPs essentially involve privatising business gains and socialising the losses, or because they've been an abject failure almost everywhere they've been tried, but because one of…

economy privatisation

Post

Open mike 29/11/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