--- John Black <[EMAIL PROTECTED]> wrote:

> Tedit kap wrote:
> > I have a table like
> > articleid-articledate-articletitle-articlebody
> > I am looking for a simple php script that will search my database which
> contains articles against keywords entered by the user...So, it should bring
> up that article that contains that keyword or words entered by the user. 
> > For example: 
> > select * from the_table where articletitle or articlebody contains keyword
> 
> I would suggest you look into fulltext searches as they are a lot faster 
> then LIKE searches.
> 
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Looking at the comments for the very page you link suggests that some people
have exceptionally poor performance from fulltext searchers.  Perhaps they
don't have the correct indexes on their multi-million-row tables but it does
not seem to be universal that fulltext searches are faster than LIKE searches.

James

Reply via email to