title: select values which contains specific characters in mysql
body: <p>I have a database table which contains questions in hindi and english language in same column but are separated by keyword [en] english language [en:] and [hi] hindi language [hi:] and some of them are not separated by language tags</p>
  
  <p>I want to select only that questions which have  [en] [en:] and  [hi][hi:] tags in mysql</p>