title: Combine 2 values to 1 column MySQL
body: <h2>Code:</h2>
  
  <pre><code>SELECT s.*, k.address FROM student s
  INNER JOIN address k
  ON instr(s.fulladdress, k.address) &gt; 0
  WHERE j.phonetic like '%california%' 
  </code></pre>
  
  <p>This result will display 2 rows with 2 parts of address:</p>
  
  <pre><code>30,Andre Hans, Address 1 Address 2,class IBA1001, Address 1
  
  30,Andre Hans, Address 1 Address 2,class IBA1001, Address 2
  </code></pre>
  
  <p>I want to display it in 1 row:</p>
  
  <pre><code>30,Andre Hans, Address 1 Address 2,class IBA1001, Address 1 | Address 2
  </code></pre>
  
  <p>How i can do that?</p>