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