XF 2.2 Mass delete posts with exact word

[Max]

Hi
how to mass delete all the posts with exact word only?

eg..
Want to delete posts only with the word "Yes"
Not
"Yes i am"
"I like, Yes"

This can easily be done with phpmyadmin, but will it create a problem in xenforo?

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/delete-posts-keywords.5984/

 

[Mr Lucky]

Andy’s addon is good.

Yes

 

[Max]

You might like this add-on:

https://xenforo.com/community/resources/delete-posts-keywords.5984/

Is it have the option to delete posts which have the exact word only? seems like its deleting any post matching the keyword.

 

[Mr Lucky]

I don’t get how you could delete all posts with the word yes and still have a viable forum.

 

[Mr Lucky]

OK I think I see what you mean. The word yes but no other words?

 

[Mr Lucky]

Yes

 

[Max]

OK I think I see what you mean. The word yes but no other words?

yeah. and i took "yes" as an example. actually i want to delete some spammers posts containing only his company name.

 

[Kirby]

$posts = \XF::finder('XF:Post')->where('message', '=', 'Yes')->fetch();
foreach ($posts as $post)
{
    $post->delete();
}

 

[Max]

$posts = \XF::finder('XF:Post')->where('message', '=', 'Yes')->fetch();
foreach ($posts as $post)
{
    $post->delete();
}

Thank you very much.
How to use regex within this?