title: how to get numeric values form sql query
body: <p>My problem is I have a table in which offers are stored and I want to display only those records who have 50% (the substring '50%' in them).</p>
  
  <p>This is my table Schema:
  <a href="https://i.stack.imgur.com/d6g9B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d6g9B.png" alt="enter image description here"></a>
  An Example record would be:</p>
  
  <blockquote>
    <p>FLAT 50% Off on Essel world entry tickets and more.<br>
    FLAT 50% Off on Rs<br>
    2495 &amp; above. U.S polo - Upto 50% off</p>
  </blockquote>
  
  <p>How would I go about composing an SQL query to select these? The column name of the field is called <code>coupon_name</code> </p>