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]