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

Reply via email to