title: MySql Regular Expression Select Columns Matching (dynamic)multiple Values within Stored Procedure
body: <p>I am trying to generate a query where I want to select columns(text) matching multiple values.</p>
  
  <p>eg: I have two columns, id and description. suppose my first row contains description column with value</p>
  
  <blockquote>
    <p>Google is website and an awesome
    search engine</p>
  </blockquote>
  
  <p>, second row with description column value </p>
  
  <blockquote>
    <p>Amazon website is an awesome eCommerce
    store</p>
  </blockquote>
  
  <p>I have created a query </p>
  
  <blockquote>
    <p>Select * from table_name where
    description  REGEXP 'Website \|
    Search'</p>
  </blockquote>
  
  <p>It returns both the rows i.e with both google and amazon, but i want to return only google as i want those rows with both the words <strong>website</strong> and <strong>search</strong> also the number of words to be matched is also not fixed, basically the query I am creating is for a search drop down, </p>
  
  <p>All the words that are passed should be present in the column, the order of the words present in the column is not important. If there are other better options besides using regex , please do point out.</p>
  
  <p><strong>Editing: the number of words that are passed are dynamic and not known, the user may pass additional words to be matched against the column. I would be using the query within a stored Procedure</strong></p>