Good evening List,
I have a problem on my fulltext-search. If I create the sample table from
MySQL-Doc it runs perfect.
If I create my own - it doesn't. I can't say more: Here is my dump:
CREATE TABLE tcl (id int(10) primary key not null, description varchar(254),
date timestamp, value int(11), department tinyint(3), text text,
fulltext(description,text))
If I take a look on my table stucture (using phpmyadmin or describe) it
seems ok.
Now I do some inserts like this:
INSERT INTO tcl VALUES(1,'dummy',,0,1,'lorem ipsum lorem ipsum');
If I take a look again it look harmless.
Now I do this
SELECT * FROM tcl() WHERE MATCH(description,text) AGAINST('ipsum')
or
SELECT tcl.'text' FROM tcl() WHERE MATCH(text) AGAINST('ipsum')
And nothing happes, this means, it retuns 0 rows.
Any suggestions?
Jan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
