title: MySQL: How can I SELECT all columns that contains a combination of a specific set of numbers
body: <p>I have a MySQL table with 1 column containing a set of numbers eg. 10, 18, 22, 56, 89 etc. I have about 6000 rows of different user inputs with the same column of different values. </p>
  
  <p>I want to select the columns that have the exact match of numbers I am searching for. 
  eg. <code>SELECT * from my_table WHERE column CONTAINS num1, num2, num3</code>. I cant seem to get it to work. It still selects all the records containing even one of the value and not the exact match.</p>
  
  <p>My database is a lottery table and I want to be able to find the winners in 2 to 6 number matches - after the result draw.</p>
  
  <p>Thanks in advance for your help!</p>
  
  <p><em>EDIT</em> I want to return only columns containing a fixed set of numbers (string). Not all columns containing any of the numbers.</p>