On Wed, 2 Apr 2003, Shamit Verma wrote:
The replay on the webpage says that:
Nope. That would be a really slow search since mysql cant use any
indexes and a table scan would be the only way to find it.
Then even LIKE operator should suffer from the same performance drawback,
how does LIKE
The replay on the webpage says that:
Nope. That would be a really slow search since mysql cant use any indexes
and a table
scan would be the only way to find it.
Then even LIKE operator should suffer from the same performance drawback,
how does LIKE operator work with indexes?
Shamit Verma,
On Thursday 27 March 2003 20:59, Nick Arnett wrote:
It appears to me that fulltext phrase searches cannot include wildcards.
For example, I would expect app* serv* to match application server,
application services, etc. But it returns no results, so I'm having to
run each variation