title: How use sql "like" in PyMongo?
body: <p>How use sql "like" in PyMongo?</p>
  
  <pre><code>&gt;&gt;&gt; db.houses.find().count()
  11616
  &gt;&gt;&gt; db.houses.find({"hid":u"16999"}).count()
  1
  &gt;&gt;&gt; db.houses.find({"hid":u"/9/"}).count()
  0
  </code></pre>
  
  <p>The <a href="http://www.mongodb.org/display/DOCS/SQL+to+Mongo+Mapping+Chart" rel="noreferrer">documentation</a> says that sql "like" (<code>SELECT * FROM users WHERE name LIKE "%Joe%"</code>) in MongoDB is <code>db.users.find ({name:/Joe/})</code>. </p>
  
  <p>If you specify a query directly to the cli-client interface mongodb, then everything works correctly, but does not work in pymongo.</p>
  
  <p>What is the problem?</p>
  
  <p>Thanks.</p>