title: How can I update records in sphinx search index by sql query?
body: <p>I have a problem when I want update record in sphinx search index </p>
  
  <pre><code>mysql&gt; UPDATE indexname SET field = 'value' where id = 295;
  
  ERROR 1064 (42000): sphinxql: syntax error, unexpected QUOTED_STRING, expecting CONST_INT (or 3 other tokens) near ''value' where id = 295'
  </code></pre>
  
  <p>Is it possible to update some text field in disk index (not RT)</p>
  
  <p>My sphinx version is: 2.1.7-id64-release (rel21-r4638)</p>
  
  <p>Thanks for some ideas:)</p>