Re: Re: Subselect ?
| From: | NetCentrex) | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: Re: Subselect ? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32454@lists.php.net to get a copy of this message | ||
try this
SELECT DISTINCT id-script FROM YOURTABLE where id_language = 'SELECTED LANGUAGE' ;
no ?
Justin Patrin wrote:
Christine Clerc wrote:-- Alban Médici R&D software engineer ------------------------------ you can contact me @ : alban.medici@fr.netcentrex.net http://www.netcentrex.net ------------------------------Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need to retrieve the list (without duplicate) of id-script that are described in one language and NOT in another. Is there hope ? Any help would be welcome. ChrisMaybe give us a sample of the SQL you wish to use? You can probably get it done without a sub-select. That being said, the newest versions of MySQL support sub-selects, but you'd have to use an unstable version.