Hello Nate,
Monday, 24 September, 2001, 19:56:47, you wrote:
NF I built my database and then used the command:
NF ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid)
NF But if I try to search with this command:
NF SELECT title, recentdata, specialsound,uniqueid FROM disc
Hi!
I built my database and then used the command:
ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid)
But if I try to search with this command:
SELECT title, recentdata, specialsound,uniqueid FROM disc WHERE MATCH
(title) AGAINST ('Superman')
Hi!
On Aug 28, Alok K. Dhir wrote:
select * from Laws WHERE MATCH(Line) AGAINST ('growth
hormone') AND Line like '%growth hormone%' ORDER BY ID;
This defeats the purpose of the fulltext index, don't you think?
Al
Not really, as fulltext index is used to find the documents that
Hi!
On Aug 28, Ed Carp wrote:
How do I do exact phrase matches using FULLTEXT?
I have this 2 million row table, full of text data, that I want to search
for an exact phrase. When I say:
select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
It works correctly, returning 1
On Aug 28, Ed Carp wrote:
How do I do exact phrase matches using FULLTEXT?
I have this 2 million row table, full of text data, that I want
to search
for an exact phrase. When I say:
select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
It works correctly, returning
Alok K. Dhir ([EMAIL PROTECTED]) writes:
select * from Laws WHERE MATCH(Line) AGAINST ('growth
hormone') AND Line like '%growth hormone%' ORDER BY ID;
This defeats the purpose of the fulltext index, don't you think?
Not really - since the WHERE clause is executed left to right, the