Answer to my query "select distinct" http://lists.mysql.com/mysql/175839 <http://lists.mysql.com/mysql/175839>
To select properly only one time one element of a column in a list (here the journal name) I have to add a selection on the end of the name that it is not a space or a return ! Both are found to be necessary even if in my list no space or return are present in the journal names. It appears that SELECT is extended to the name , name\n and name\r ! SELECT DISTINCT journal FROM reference WHERE journal <> ' ' AND journal NOT LIKE '%\n' AND journal NOT LIKE '%\r ' ORDER BY journal Gives the required list with only one time each journal name; Thanks again for suggestions. Luc BARBIER _____________________________________________________________ Luc BARBIER DSM/DRECAM/SPCSI Bāt 462 CEA Saclay 91191 Gif-sur-Yvette Cedex E-Mail : [mailto:[EMAIL PROTECTED] Tel : 33 (0)1 69 08 51 60 FAX : 33 (0)1 69 08 84 46
