MySQL FULLTEXT
Posted: Sat Sep 01, 2007 7:32 pm
feyd | Please use
Populate it with some data:
When I query using
I get the first table row returned.
However when I query using
I STILL get the first table row returned;
Now if I add another column to the table:
so that there are now 2 entries in the table and I query using
I get an empty set.
Any ideas anyone? Thanks in advance.
Chonk
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
've been racking my brain all day on this. I've done some searching and have tried a few different things from the forums that don't work. Here's my issue.
I create a table:
[syntax="sql"]
CREATE TABLE `Builders` (
`ID` INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
`Name` TEXT,
`BizName` TEXT,
FULLTEXT (Name,BizName)
) TYPE = MYISAM ;Code: Select all
INSERT INTO Builders (Name,BizName) VALUES ('Jeffrey Yonker','Chonk Digital Design');Code: Select all
SELECT * FROM Builders WHERE MATCH (Name,BizName) AGAINST ('Jeffrey');However when I query using
Code: Select all
SELECT * FROM Builders WHERE MATCH (Name,BizName) AGAINST ('Joe');Now if I add another column to the table:
Code: Select all
INSERT INTO Builders (Name,BizName) VALUES ('Joeseph Bowers','Bowers Construction');Code: Select all
SELECT * FROM Builders WHERE MATCH (Name,BizName) AGAINST ('Jeffrey');Any ideas anyone? Thanks in advance.
Chonk
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]