I've just crossed 100,000 posts today :)

AnandGupta

Well-Known Member
Licensed User
Interesting question.
B4X:
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE 'please start a new thread%'
The answer is 1,122.
Should ya put % before too,
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE '%please start a new thread%'

as the text sometimes are in next line :)

Regards,

Anand
 

Erel

Administrator
Staff member
Licensed User
hould ya put % before too,
SELECT count(*) FROM `xf_post` WHERE `user_id` = 1 AND `message` LIKE '%please start a new thread%'

as the text sometimes are in next line
I actually did it. The result is about 1800. However there are many cases where I gave an answer to one question and then asked the OP to start a new thread for the second question. So I don't add it to the number of non-informative posts.

Don't take it too seriously. The administration posts are very important, not less important than other posts...
 
Top