Importing Excel Data in MySql

2004-10-21 Thread Bertrand Gac
Hello We have clients sending us xls file. We export them as csv files, using commas or semi-colons. as delimiters and then make an import in mysql. Problem : some of the fields, containing texts, have sometimes already a comma or a semi-colon in them...and when we import, of course MySql thin

Re: match a fulltext search with a "-" dash, can't match if - exist

2004-10-17 Thread Bertrand Gac
> mysql> select * from fullsearch where match (title,body) against ('018-E'); > Empty set (0.00 sec) > > > it returns an empty set, is it possible to also search with "-" dash? chars? I'm not an expert but others will correct me : In a fulltext search, the search string must be at least 4 char