php + sql search

Thomas Hurst tom.hurst at clara.net
Fri Nov 1 13:06:56 GMT 2002


* Paul Civati (paul at xciv.org) wrote:

> I'm not an SQL/db expert, but I believe if you want to be able to do
> free text search (I think is the right term?) then you would have to
> use some non-standard database add-on.  Oracle has context (v8) and
> intermedia (v9) for more complex searching functionality AIUI.

MySQL has bundled full text searching:

  http://www.mysql.com/doc/en/Fulltext_Search.html

With boolean matching (+word -otherword) in version 4.

-- 
Thomas 'Freaky' Hurst  -  freaky at aagh.net  -  http://www.aagh.net/
-
Who to himself is law no law doth need,
offends no law, and is a king indeed.
		-- George Chapman




More information about the Ukfreebsd mailing list