title: How to get "select 1" data
body: <p>I'm trying to trying to determine existence of a value in the database, so I choose to use <code>Select 1 From table</code>, but how can I get the data?
  I want to check two people are buddies, and here are my models</p>
  <pre class="lang-golang prettyprint-override"><code>type Buddy struct {
      ID      uint64 `gorm:&quot;primarykey&quot;`
      UserID  uint32
      BuddyID uint32
  }
  </code></pre>
  <p>this is the gorm sql I've tried</p>
  <pre class="lang-golang prettyprint-override"><code>// select 1 from buddies where user_id=? and buddy_id=?
  type Result struct {
      Exist uint32
  }
  exist := &amp;Result{}
  orm.DB.Debug().Table(&quot;buddies&quot;).Raw(&quot;SELECT 1 as exist FROM buddies WHERE user_id = ? and buddy_id = ?&quot;, userID, buddyID).Scan(exist)
  </code></pre>
  <p>but I didn't get anything in exist.Exist</p>