title: Use * Like operator to search all columns of table in sql query
body: <p>Here I have a question if it is possible to search all columns of my table in database in query, not using <code>Like</code> operator to my each column as:</p>
  
  <pre><code>SELECT * FROM banquets WHERE bqtID LIKE '%Value1' OR bqtName LIKE '%Value2';
  </code></pre>
  
  <p>But I want to use <code>*</code> instead of using multiple <code>Like</code> operator with my columns as like(Is it possible?):</p>
  
  <pre><code>SELECT * FROM banquets WHERE * LIKE '%Value%';
  </code></pre>
  
  <p>Since I've not tested it, I just want to know if it's possible or not. If not then how can I accomplish it? Or what can be alternative of that thing?</p>
  
  <h2>Edit:</h2>
  
  <p>The question that is marked as duplicate is about using <code>WHERE</code> clause with mentioning all columns of table separately but I want to use it <code>*</code> in place of columns.</p>