On Fri, Dec 07, 2001 at 09:30:47AM +0550, [EMAIL PROTECTED] wrote:
> Can anyone tell me how would i replace the following query with a "="
> SELECT * from table_name WHERE name LIKE "%name%";
> I want to have the same functionality like "LIKE" but having no LIKE word in
> it.
> Basically i want it for a search engine and i heard that using LIKE decreases
> the speed like nothing as compared to "="

Perhaps you could use a FULLTEXT index.

Failing that, basically what you're saying is that you want one thing
to be just like another, even though it's quite different.  Which just
doesn't make a lot of sense.

> -TIA
> Sharmad

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to