title: MySQL user wildcard use BETWEEN
body: <p>I have a problem in MySQL Query, this is my Query:</p>
  
  <pre><code>select `BKC ID`,`Nama Pengirim`,sum(`&amp;#162; Koli`) as `Koli`,sum(`Harga`) as `Harga Barang`, sum(`Uang Administrasi`) as `Admin.`, sum(`Uang Penerus`) as `Uang Penerus`, `Tujuan`
  from `transaksi` 
  join `transaksi barang` 
  ON `transaksi barang`.`BARANG ID` LIKE concat(`transaksi`.`BKC ID`, '-%')
  WHERE `BKC ID` BETWEEN ('%1705%' AND '%1706%')
  group by `BKC ID` DESC
  </code></pre>
  
  <p>but that query is ERROR, the error is <strong>can't to use WILDCARD at BETWEEN function</strong>, </p>
  
  <p>i can't to find alternatif @ google.com (Seaching) 
  Type of <code>BKC ID</code> is <strong>varchar</strong>, example <strong>"ABC170101102912"</strong> </p>
  
  <p><strong>thanks for advance.</strong></p>