Explore the archive

Archives: @author_full Ralph Malcolm

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

    Date counts load after the page opens. You can also enter a date range above.

    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: relevance Results: 1–7 of 7

    Post

    tis the season

    · Ralph Malcolm

    I am beginning to think John Key's attempt to turn statements that involve him into 'personal attacks' might be catching on. Check out this story, on the TVNZ website, but sourced to Newstalk ZB, that accuses Trevor Mallard of 'lashing out' at Cameron Bagrie over his loose with the truth report on ...

    john key public services

    Post

    National ‘bereft of compassion’

    · Ralph Malcolm

    That is the reported view of the secretary of the Sikh Council of New Zealand in response to some attention grabbing behaviour from National Manakau East candidate in the wake of the tragic shooting of Natjev Singh. Specifically the article says: Mr Verpal Singh said they were "utterly disappointed ...

    crime national

    Post

    TVNZ and the Nats

    · Ralph Malcolm

    As Paul Henry continues his party political broadcasts for the National Party on Breakfast TV, a curious coincidence of timing occured on Sunday. John Key devoted part of his speech to a National regional conference to the Nats plans on how to deal with "P". The rest of the speech was pretty much a ...

    john key Media national tv

    Post

    Paul Henry must go

    · Ralph Malcolm

    This morning's performace on breakfast TV by Paul Henry was a disgrace. His complete lack of objectivity on the rail and ferry buy-back was even more biased and partisan than we have come to expect from him. Despite Guyon Espiner's best efforts to provide some objective analysis of the government's ...

    Media spin

    Post

    Granny Herald’s campaign fails

    · Ralph Malcolm

    Hidden away today at the bottom of the Herald's story on further data from the latest DigiPoll is the news that only 3.8% of those surveyed rate the Electoral Finance Act as a vote influencing issue. You can just about feel the Herald's despair that despite an unprecedented, wholly unbalanced and ...

    election funding Media

    Post

    Which was it David- anonymous donation or trust?

    · Ralph Malcolm

    The Hysteria- with a capital H- over at Kiwiblog around the Electoral Finance Bill has been mystifying for many of us in blogland. Sure David Farrar is a key National Party figure, and is no doubt worried that the Bill will mean his party will no longer be able to buy elections, or more rightly use ...

    dpf

    Post

    The view from the back of the National class….

    · Ralph Malcolm

    Last night's debate on the Youth Minimum Wage Bill was (as noted earlier) a triumph for progressive politics and for young people. It was not such a triumph for David Bennett, who apparently is National's MP for Hamilton East. His speech (mp3 - 2MB) during the debate takes incoherence to hitherto ...

    national