You are viewing a single comment's thread from:

RE: [STEEMSQL] A deep analysis of Steemians gratefulness

in #stats • 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 in #stats by
$0.00
    1 vote
    Reply 1
    Sort:  
  • Trending
    • [-]
     8 years ago  

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

    $0.00
      Reply