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
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 row, MUCH faster than doing a select
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