title: Sphinxql Replace() function like mysql
body: <p>i can able to find search on mysql such as example below;</p>
  
  <p>Record is : I'Histoire
  Query search :IHistoire</p>
  
  <p>with this sql query i can able find word with ' string.</p>
  
  <p>select
  kitap_id,kitap_Adi,turu,fiyati,kargo,satici,yazari,yayinevi,yayin_Yili,yayin_Yeri,kucuk_Re
  sim,kondisyon FROM kitaplar WHERE onay='1' and (REPLACE(kitap_Adi,'''','' ) like
  '%IHistoire%' OR yazari like '%IHistoire%') order by fiyati asc LIMIT 0,5;</p>
  
  <p>But on sphinx how can i do this? Query below i find matches i want also to find the ones with '.</p>
  
  <p>select
  kitap_id,kitap_Adi,turu,fiyati,kargo,satici,yazari,yayinevi,yayin_Yili,yayin_Yeri,kucuk_Re
  sim,kondisyon from test1 where match ('@(kitap_Adi,yazari)(IHistoire)') and onay=1 order
  by kitap_Adi asc, fiyati asc LIMIT 0,5\G;</p>
  
  <p>How can i do that replace() in sphinxql, i can able to do on mysql side bu how to do on sphinx side?</p>
  
  <p>Thanks</p>