title: Retrieve client ip address in mysql
body: <p>I'm trying to get with a simple SQL statement the IP address of the client. I do not want to use PHP or other techniques. Only pure SQL. When I use </p>
  
  <pre><code>SELECT USER();
  </code></pre>
  
  <p>I get</p>
  
  <pre><code>dbouser@host.i.do.not.care.of
  </code></pre>
  
  <p>When I use </p>
  
  <pre><code>SELECT CURRENT_USER();
  </code></pre>
  
  <p>I get</p>
  
  <pre><code>dbouser@%
  </code></pre>
  
  <p>But how do I get the plain IP? Thanks a lot in advance.</p>