title: Storing Ratio as number in MySQL database column
body: <p>I want to store ratios in my database. An example of ratios are: <code>4:5, 6:7</code>, etc. I want to make a query based on the ratios.</p>
  
  <p>I thought about storing them as decimals (9,3) in MySQL in order for to query them as numbers and not texts. A ratio can be a long number like <code>1.77777777778</code>  for 16:9.</p>
  
  <p>What is the appropriate way to store it in MySQL database in order to query it later.</p>