Search through wp_posts and do regex replace

Hello ??

I have a case with a few thousand blog entries. Inside the article content (classic editor based) is redundant content. This redundant content is always at the very end of the post and it always starts with the same word, let’s say the word is “axolotl”.

Can I use Better Search Replace to search for that word and then replace it and everything that follows with blank?

If I can, would you be able to provide an example for my use case?

Thanks!