title: org.hibernate.QueryException: unexpected char: '`'
body: <p>I am trying use the following following query using JPARepository but it is throwing </p>
  
  <blockquote>
    <p>org.hibernate.QueryException: unexpected char: '`' " </p>
  </blockquote>
  
  <p>exception.</p>
  
  <p>Here is the named query I have:</p>
  
  <pre><code>@NamedQuery(name = "shift_planner.fetchThisWeekShiftDetails",
           query = 
           "SELECT r.resouce_name,s.shift_name,sp.plan_date 
            FROM elias.shift_planner sp, elias.resources r, elias.shifts s 
            WHERE sp.resource_id=r.resource_id and sp.shift_id=s.shift_id 
             AND YEARWEEK(`plan_date`, 1) = YEARWEEK(CURDATE(), 1)"
  )
  </code></pre>