This is my SQL query:
SELECT seriesno, governor, descr, boxno, year, eyear, docno
from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches
'*$searchterm*' or descr matches '*$searchterm*';
So as you can see, its gonna need some work to make it do fulltext
searching of the descr field.
From: Adam Williams [EMAIL PROTECTED]
This is my SQL query:
SELECT seriesno, governor, descr, boxno, year, eyear, docno
from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches
'*$searchterm*' or descr matches '*$searchterm*';
Looks like you're doing the equivilent to a MySQL LIKE
Hello,
I am selecting a field in a database called description for keyword
searching. The field contains names of people, states, years, etc. When
someone searches for say holmes north carolina the query searches for
exactly that, fields which have holmes north carolina, and not fields
that
.
-Marques de Santillana.
~~~
-Original Message-
From: Adam Williams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 12:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] keyword searching
Hello,
I am
