MATCH (Full Text) IN BOOLEAN MODE

2004-08-19 Thread B . Kamer
hi, a boolean mode full text search doesn't sort automaticly as stated in the docs, but it also isn't possible to select the match value (the score) any more. (is is always 1) consider this query; SELECT id, titel, MATCH (titel) AGAINST ('mozart') AS score FROM cmp_composities WHERE MATCH (t

LOAD DATA INFILE & latin1

2004-08-04 Thread B . Kamer
hi all i'm having the following issue, that i'm not sure how to resolve i have a comma seprated file, which imports fine with; LOAD DATA LOCAL INFILE 'path/top/file.txt' REPLACE INTO TABLE `tablename` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r'; but lines with latin1 chara