title: mysql two/three column treat as one and then LIKE search and order
body: <p>Is it possible to treat two or three column treat (merge) as one column and search with <code>LIKE</code> keyword from that one column and ORDER result as desired?</p>
  
  <p>my columns</p>
  
  <pre><code>| to_place   | from_place  | departure_place|
  |:-----------|------------:|:------------: |
  | Same       |    Place    |    Line     
  | Rangpur    |    Dhaka    |    Chittagong   
  | Badda      |    bogra    |    hello     
  | Shyamoli   |    rajshahi |    mohammadpur      
  | test       |    test1    |    adabor    
  | another    |    test2    |    kurigram
  </code></pre>
  
  <p>so i want these 3 columns in one column in my <code>SQL</code> so that i can order them </p>