and typed "-" in the box next to "as spaces"

There is no "as spaces" on super search. There is a field for you to specify what string you want to use as a separator between search terms for which the "default is spaces". So type space, then oh, then en, then space (" on ") as your search term and set the delimter to be anything other than space, oh, or en. Or use the regex "\bon\B".

Yes, I've tested both of these suggestions.

Or use the regex "\bon\B".

Hmm, that does 'work'. But what definition of regex are you using? In perlre, it says '\b' should match a word boundary transition, whether its from a word to a non-word or a non-word to a word character transition. So, '\b' should match "abc def ghi" (among other places) both before the "d" and after the "f". '\B' would match the places in between the letters, like between "a" and "b".

Update:Ahh, ok. it all makes sense now :-)

See (tye)Re: new super search. You can use MySQL's [[:<:]] and [[:>:]] directly if you find that less confusing.

        - tye (see also this)
Read more... (1283 Bytes)

fred flinstone
barney rubble
dino

You would enter it as:

fred flinstone;barney rubble;dino
separator: ;

fred_flinstone barney_rubble dino
separator: _

-Blake

He said to put a space between the letters and the delimiters. Of course, then you wouldn't get things that begin or end with "on"...and I can't get regexes to work either...

In the simple search (at the top of every page here), when you search for a single letter (say "x"), it searches for records where ' '+title+' ' like '% x %', which allows the space-separated "x" to appear at the front or back of the title without having to incur the CPU penalty for pulling in the powerful regex engine.

That would be a reasonable enhancement to super search's title searching capabilities, especially if it is made smart enough to avoid the space concatenation when there are no search terms that begin and/or end with a space.

Any takers?

        - tye (one of those who rlike 'Tye')