title: MySQL datatype to store pair of values?
body: <p>I have a table that stores a list of expected parameters that are compared against a real set of data to check if they are within range. There are a dozen or so labeled parameters, and each parameter is either an int, float, or varchar. Each parameter can have either a range like (3.5 - 6.7) or a list of possible values like ('localizer', 'local a') or (4,5,8)</p>
  
  <p>This will be dynamic, so the user will be able to add to and update the list of possible values. I don't think I want to add in lots and lots rows of possible parameters unless I can't find a way to do this in the schema.</p>
  
  <p>What is the best way to store these possible parameter values in a SQL table?</p>