title: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: select * from `songs` where `id` = 5 limit 1)
body: <p>I am trying to get specific data from the database by using column <code>SongID</code> when a user clicks a link but I am getting this error: </p>
  
  <blockquote>
    <p>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where
    clause' (SQL: select * from <code>songs</code> where <code>id</code> = 5 limit 1)</p>
  </blockquote>
  
  <p>The Controller Class:</p>
  
  <pre><code>&lt;?php namespace App\Http\Controllers;
  
  use App\Http\Requests;
  use App\Http\Controllers\Controller;
  
  use Illuminate\Http\Request;
  use DB;
  
  class SongsController extends Controller {
      public function index()
      {
          $name = $this-&gt;getName();
          $songs = DB::table('songs')-&gt;get();
          return view('songs.index', compact('songs','name'));
      }
      public function show($id)
      {
          $name = $this-&gt;getName();
          $song = DB::table('songs')-&gt;find($id);
          return view('songs.show', compact('song','name'));
      }
  
      private function getName()
      {
          $name = 'Tupac Amaru Shakur';
          return $name;
      }
  }
  </code></pre>
  
  <p>Migration:</p>
  
  <pre><code>    public function up()
      {
              Schema::create('songs', function($table)
              {
                  $table-&gt;increments('SongID');
                  $table-&gt;string('SongTitle')-&gt;index();
                  $table-&gt;string('Lyrics')-&gt;nullable();
                  $table-&gt;timestamp('created_at');
              });
      }
  </code></pre>