Quick Links

Re: Fulltext Index and Search

From:	Holger Marzen <holger(at)marzen(dot)de>
To:	Stefan Weiss <sw(at)typ1(dot)de>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Fulltext Index and Search
Date:	2002-02-26 21:11:28
Message-ID:	Pine.LNX.4.44.0202262203320.11837-100000@bluebell.marzen.de
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

On Mon, 25 Feb 2002, Stefan Weiss wrote:

> ist it possible to make a fulltextsearch about more than one column?

In my address book I do the following:

- First I replace every space (" ") by a percent sign.
- Then I do a select with concatenated columns in the where clause.

PHP-Code:

$sqlbedingung = "Peter Muster";
$sqlbedingung = str_replace(" ","%",$sqlbedingung);

And then a

select * from adressen where vorname||nachname ilike '%$sqlbedingung%'

You can do it with more columns.

	From	Date	Subject
Next Message	Asvin Ananthanarayan	2002-02-26 21:26:28	PostgreSQl or BerkeleyDB ??
Previous Message	Andrew Sullivan	2002-02-26 20:57:41	Re: Wisconsin Benchmark