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
Using the request :
SELECT DISTINCT journal
FROM reference
WHERE TYPE = 'article' AND etat = 'published' AND journal = 'Physical Review
Letters'
I get two type of answers
One with 'Physical Review Letters'
(WHERE `journal` = 'Physical Review Letters' )
the other with 'Physical Review