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
I once got this answer to a similar question on another group.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg00280.html
Bernhard
- Original Message -
From: Nick Arnett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 8:59 PM
Subject: Fulltext search
,
http://www.vshamit.com
- Original Message -
From: Bernhard Döbler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:01 PM
Subject: Fw: Fulltext search -- no wildcards in phrases?
I once got this answer to a similar question on another group.
http://www.mail-archive.com
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
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 separately. Can anyone confirm that wildcards, indeed,
can't be
Hi folks!
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and ranges