Re: Replace like

On Fri, Dec 07, 2001 at 09:30:47AM +0550, sharmad@goatelecom.com 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