title: Add to CONCAT() if a column is = 1
body: <p>Im trying to get a SQL query to concat "FreeShipping" to a string only if I have a '1' in <code>FreeShipping</code> field
  This is the current SQL I have but I have no clue how to use the IF statement and add the <code>concat()</code> function</p>
  
  <p>Im I suposed to make the if select between two <code>concat()</code> function?</p>
  
  <pre><code>SELECT
      `Id`
  FROM
      `product_products` as pp
  WHERE
      CONCAT(
          `Id`,
          ' ',
          (SELECT `Name` FROM `product_brands` WHERE `Id` = pp.BrandId),
          ' ',
          `ModelNumber`,
          ' ',
          `Title`
      )
  LIKE :SearchStr AND isActive = 1;
  </code></pre>
  
  <p>Expected result is only Id of products, I want to select the products by Searching for "FreeShipping"</p>
  
  <p>The <code>:SearchStr</code> is a variable</p>