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
