title: mysqldump from a query
body: <p>How can I make a mysql dump for table from a query?</p>
  
  <p>I need something like this..</p>
  
  <pre><code>mysqldump -uroot -pxxxx mydb "select * from table where name='1';" &gt;  /tmp/a
  </code></pre>
  
  <p>Thanks.</p>