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 searc
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;
---head
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
statement
> 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
news:
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 (title
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
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
http://shop
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
$
t;>".$keywords[$i]." ", $blurb);
> > }
> >
> > where $keywords is an array containing all the words searched for and
> $blurb
> > is the snippet that is returned with the search results At this stage in
> the
> > flow, I've already retriev
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 probl
already retrieved relevant records - this is in fact the last
> step before I format and display the results..
>
> Hope this helps
>
> stuart
>
>
> - Original Message -
> From: "andy" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Su
e results..
Hope this 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 wr
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 characters
14 matches
Mail list logo