title: How to use select....as and concat in rails 5
body: <p>I have a table called Student, the student table contains the id, first_name and last_name. I am trying to select and concatenate first_name and last_name and display the column as "Name". This is my query:</p>
  
  <pre><code>Student.select("concat(first_name, ' ', last_name) as 'Name'").find(201410204)
  </code></pre>
  
  <p>but it returns</p>
  
  <pre><code>SELECT  concat(first_name, ' ', last_name) as 'Name' FROM `students` WHERE `students`.`id` = 201410204 LIMIT 1
  
  #&lt;Student id: nil&gt;
  </code></pre>
  
  <p>but when i try to paste the query inside mysql workbench it return the student name that has the id 201410204 and the column name is "Name". </p>
  
  <p><a href="http://i.stack.imgur.com/s7aBH.png" rel="nofollow">Click to see the result of the query</a></p>
  
  <p>What's the problem about my code? Thanks</p>