title: mysql query to get just the 1st sentence in a paragraph
body: <p>I'm trying to copy over just the 1st sentence in a description paragraph of a product for a meta-description tag in a mysql database.  For instance. in this product description, i just need the 1st sentence to copy over from the products_description field to the products_meta_description field.</p>
  
  <p>"The Kendall Howard 8U Compact Series SOHO Server Cabinet Rack is ideal for IT setups with limited space. The sleek, durable design is specifically constructed for small businesses, home offices, or IT professionals who want a compact design without sacrificing the safety of their server rack equipment." </p>
  
  <p>should be copied to products_meta_description as:
  "The Kendall Howard 8U Compact Series SOHO Server Cabinet Rack is ideal for IT setups with limited space."</p>
  
  <pre><code>UPDATE products SET products_meta_description = products_description(1st sentence only)
  </code></pre>
  
  <p>not sure how to do that.  I'm assuming it would have find the 1st period (.) found in the paragraph and just get everything before that.  btw, i'm doing this in phpmyadmin sql query tool.  there are thousands of products so I thought this would be the easiest way to get a canned meta description tag entered for each product vs. doing it manually.</p>