--- Stoyan <[EMAIL PROTECTED]> wrote: > hi,
>
> why don't you try to use this:
>
> SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%';
That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles')
and match author against('dickens')) takes 1.3 seconds. Fulltext searching
is MU
--- Colin Faber <[EMAIL PROTECTED]> wrote:
> Ok,
>
> The message set that I noticed this morning sparked my interest in this.
>
> Currently I'm developing a search engine that will utilize mysql's
> fulltext match technology. The problem that i've run into is, I can't
> seem to find any docu
>Hi
>
>I have posted this before. You can do an AND search by using the IF()
>function.
>Its messy in the query but it works.
>Here an example of my select query - 3 inputs are checked as AND:
>
>
>SELECT author, title, year, recommend, copy, publ_desc, publ_loc,
>CEILING(IF(MATCH author AGAINS
