[PHP-users 5321] Re: MySQLでのデータの検索結果
KANAME
php-users@php.gr.jp
Sat, 9 Feb 2002 18:00:21 +0900
ゆーた＠初心者です。
> select distinct fuga from hoge;
>
> で、いけるかと・・・・
では、hogeテーブルの fugaフィールドしか表示されませんでした。
テーブル名：TEST
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋
｜ＩＤ ｜ＮＡＭＥ ｜ＵＲＬ
｜
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋
｜０００００１ ｜あいうえお ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ａ ｜
｜０００００２ ｜あいうえお ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｂ ｜
｜０００００３ ｜かきくけこ ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｃ ｜
｜０００００４ ｜さしすせそ ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｄ ｜
｜０００００５ ｜たちつてと ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｅ ｜
｜０００００５ ｜さしすせそ ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｆ ｜
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋
からNAMEで重複するものを一つにして以下のように抽出したいのです。
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋
｜ＩＤ ｜ＮＡＭＥ ｜ＵＲＬ
｜
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋
｜０００００１ ｜あいうえお ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ａ ｜
｜０００００３ ｜かきくけこ ｜ｈｔｔｐ：／
／ｗｗｗ．ｘｘｘ．ｃｏｍ／ｃ ｜
｜０００００４ ｜さしすせそ ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｄ ｜
｜０００００５ ｜たちつてと ｜ｈｔｔｐ：／／
ｗｗｗ．ｘｘｘ．ｃｏｍ／ｅ ｜
＋−−−−−−−＋−−−−−−−−−−−−＋−−−−−−−−−−−−−−
−−−−−−−−＋