Re: [Phplib-users] Search Alternatives

[Richard A. <rh...@ju...>]

At 17:36 -0500 12/2/03, Ron Phillips wrote:

>Is there an alternative to LIKE? I want to give the user the option
>search by a phrase or by each word. Two problems I'm having are too
>many LIKE queries in a single command and pulling queries where the
>word is only part of a larger word.

Does your database of choice support full text searches?


>This probably seems simple, but I had the server call too many
>connections when was testing today, so I'd like to find a solution
>that isn't creating too many connections.

No matter how many like terms you have in a query, it's still only one
query. So that sounds more like a database or web server
misconfiguration. Are you using pconnect?

 ...R.