I have a question about full text search using mysql and php.
There is text or html file data inside mysql, then I would like
to search text from these file. when I filed some text inside text box
in web site.
mysql colum has below
b_col_id, b_col, file_name
I have wrote the code;
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
also.. i just use a LIKE in you sql statement
On 8/11/05, Yui Hiroaki [EMAIL PROTECTED] wrote:
I have a question about full text search using mysql and php.
There is text or html file data inside mysql, then I would like
to search
As of Version 4.0.1, MySQL can also perform boolean full-text searches
I am running Mysql 3.x . This sounds like a simple task to me. Is it
not
implemented in 3.x?
It does not have to be OR, NOR or anything, just AND
I've never tried it, but you might be able to get away with
SELECT columns FROM
I do get results for islands in greece as well. How can I specify in my
statement, that both words have to be present?
From the MySQL manual:
As of Version 4.0.1, MySQL can also perform boolean full-text searches
using the IN BOOLEAN MODE modifier.
mysql SELECT * FROM articles WHERE MATCH
As of Version 4.0.1, MySQL can also perform boolean full-text searches
I am running Mysql 3.x . This sounds like a simple task to me. Is it not
implemented in 3.x?
It does not have to be OR, NOR or anything, just AND
merlin
Larry E . Ullman [EMAIL PROTECTED] schrieb im Newsbeitrag
Hi fellowes,
I am working on a full text search in php and mysql. It workes pretty good,
with one exception.
If two words are entered, I do get results for each words in seperate as
well.
Examle:
carribean islands
I do get results for islands in greece as well. How can I specify in my
Hi guys can anyone point me to some resources with regard to doing full-text searches
in php. I looked at the mySQL docs and there doesnt seem to be much there.
TIA.
Angelo
Hello,
I want to use mysql's full text search capabilities
with two different tables. Can i join tables using
full text search? I am using mysql 3.23.55
thanks
Hardik
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
Hi there,
I am trying to write a php script to perform a full text search on a mysql
db. I do a match against... and it digs out some results out of the db.
There are 2 problems:
1. How can I restrict the results to e.g. 100 characters, but to make sure
the keyword is within this 100
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 9:32 PM
Subject: [PHP-DB] full text search and how to underline keyword in results
Hi there,
I am trying to write a php script to perform a full text search on a mysql
db. I do a match
ROTECTED]
Sent: Sunday, August 25, 2002 9:32 PM
Subject: [PHP-DB] full text search and how to underline keyword in results
Hi there,
I am trying to write a php script to perform a full text search on a
mysql
db. I do a match against... and it digs out some results out of the db.
The
andy,
I find the PCRE regex option easier to work with. Herewith a solution which
takes care of case (without changing the original text), and without regard
to spaces or other characters (including the first and last characters of
the string - which you didn't mention/identify as potential
is helps
stuart
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 9:32 PM
Subject: [PHP-DB] full text search and how to underline keyword in
results
Hi there,
I am trying to write a php script to perform a f
The first argument passed to eregi_replace is
.$keywords[$i].
You are concatenating the string and a space on the end and front. This was
obviously used as a hack to make sure only full words were highlighted. A
fix for this? A simple hack would be to take out the spaces, so it is simply
14 matches
Mail list logo