title: skype: how to read chat message using main.db
body: <p>I have tried upto a level but after that I am stuck. Let share steps I followed:</p>
  
  <ol>
  <li>I can see <code>main.db</code> file at this location <code>C:\Users\Admin\AppData\Roaming\Skype\paul.lowry198</code>. </li>
  <li>To open this <code>main.db</code> file I have installed <a href="http://sqlitebrowser.org/" rel="noreferrer">SQL Lite BB Browser</a> application. </li>
  <li>This application can show all existing tables in DB. There is one table <code>chats</code>. On this table I am firing a query <code>select * from Chats where friendlyname = 'Jimmy Trevor';</code> It resulted 69 results.</li>
  <li>Now after this how to read the message that he wrote but deleted(or any message) before I could read it.</li>
  </ol>
  
  <p>What could be the correct query that can show me the message?</p>