{"url":"https://monmon.hateblo.jp/entry/20110115/1295099252","title":"CakePHP\u306efind\u3067\u8907\u6570\u306e\u30ab\u30e9\u30e0\u306eDISTINCT","blog_url":"https://monmon.hateblo.jp/","provider_url":"https://hatena.blog","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmonmon.hateblo.jp%2Fentry%2F20110115%2F1295099252\" title=\"CakePHP\u306efind\u3067\u8907\u6570\u306e\u30ab\u30e9\u30e0\u306eDISTINCT - \u3053\u3093\u306b\u3061\u306f\u3053\u3093\u306b\u3061\u306fmonmon\u3067\u3059\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2011-01-15 22:47:32","author_name":"lesamoureuses","provider_name":"Hatena Blog","image_url":null,"author_url":"https://blog.hatena.ne.jp/lesamoureuses/","type":"rich","height":"190","description":"CakePHP\u306efind\u30e1\u30bd\u30c3\u30c9\u3067\u8907\u6570\u306e\u30ab\u30e9\u30e0\u306eDISTINCT\u3092\u5b9f\u884c\u3057\u305f\u3044\u306a\u3068\u601d\u3044cookbook\u3092\u78ba\u8a8d\u3057\u305f\u306e\u3067\u3059\u304c\u3001 \u30b5\u30f3\u30d7\u30eb\u306b\u306f1\u30ab\u30e9\u30e0\u306e\u3082\u306e\u3057\u304b\u306a\u3044\u3002 DISTINCT \u30af\u30a8\u30ea\u3092\u7528\u3044\u305f\u7c21\u5358\u306a\u4f8b\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002MIN() \u3084 MAX()\u3001\u305d\u306e\u4ed6\u306e\u6f14\u7b97\u5b50\u3082\u3001\u540c\u3058\u3088\u3046\u306b\u6271\u3048\u307e\u3059\u3002 array('fields'=>array('DISTINCT (User.name) AS my_column_name'), 'order'=>array('User.id DESC')) \u3053\u308c\u306b\u5023\u3063\u3066\u305d\u306e\u307e\u307e2\u30ab\u30e9\u30e0\u3067\u3084\u3063\u3066\u307f\u305f\u3082\u306e\u306e\u3001SQL\u6587\u306e\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u56f0\u3063\u305f\u3002 \u3067\u3001\u7d50\u679c\u3001findAll\u3092\u4f7f\u3048\u3070\u826f\u2026","width":"100%","blog_title":"\u3053\u3093\u306b\u3061\u306f\u3053\u3093\u306b\u3061\u306fmonmon\u3067\u3059\uff01","categories":["php","cakephp"]}