MySQL 3.22.32 and dots in db name

2001-07-11 Thread Marc Delisle
Hi, is it true that dots were legal in MySQL 3.22.32? Thanks Marc Delisle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

"Match" does not find it, but "Like" finds it

2001-05-28 Thread Marc Delisle
is, some words, like "Netscape" or "Windows", are never found with MATCH. Other words of the same length are found. However, if I use a LIKE, they are found: select titre from sites where contenu like '%Netscape%' I did not see those words that don't work, i

Re: Another index question

2001-05-25 Thread Marc Delisle
Did you try EXPLAIN before SELECT? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#EXPLAIN Mike Baranski a écrit : > > For the following select: > > SELECT DISTINCT badge_history.xact_date AS xact_date, (...) -- Marc Delisle

Version 3.23.38 and show databases

2001-05-25 Thread Marc Delisle
my applications work ok under 3.23.38, because they know the database and table names. Any ideas? -- Marc Delisle Service de l'informatique Collège de Sherbrooke, Québec - Before posting, pl