Re: Fulltext Index and Search

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.


--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1