title: Concat select query with like %string%
body: <p>Here is the simplified query that doesn't work.</p>
  
  <pre><code>SET @abc = CONCAT('%','string','%');
  
  SET @query = CONCAT('SELECT * 
  FROM table 
  WHERE column LIKE ',@abc);
  
  PREPARE stmt FROM @query;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
  </code></pre>
  
  <p>I need to use CONCAT with SELECT because there lots of other variables in real query.</p>
  
  <p>Real query works fine when I use some simple <strong>COLUMN=xyz</strong> in <strong>WHERE</strong> clause. But nothing works when I try to use <strong>LIKE %xyz%</strong>...</p>