Sort:  
  • Trending
    • [-]
     8 years ago  

    I used the following query:

    SELECT TOP 20
    Author,
    COUNT(*) AS [Post]
FROM
    TxComments
WHERE
    body LIKE '%Спасибо%'
GROUP BY
    Author
ORDER BY
    COUNT(*) DESC

    It is less efficient than using CONTAINS() or FREETEXT() but these can't be used as full text search catalog is based on English locale.
    If you need more help, please use steemsql channel on steemit.chat

    [-]
     8 years ago  

    I did not find any word "спасибо" at linkback-bot-v0

    $0.00
      Reply