How to write a regular expression to remove the end of a string?

Question

Regular Expressions

There are articles like tr98000-TS, we98010-TS, etc. in the database (.sql file).
I need to remove everything after the hyphen along with it to end up with tr98000, we98000, etc.
If I make an expression for searching -TS , then important things like product1 -TS .jpg are deleted from the database.
How can I make an expression to find -TS exactly after any 2 alphabetic characters followed by 5 any digits?

Answer 1

How to compose an expression to find -TS exactly after any 2 alphabetic characters followed by 5 any digits?
https://regex101.com/r/GO1dm1/1

Answer 2

([a-zA-Z]{2,2}\d{5,5})-.*
https://regex101.com/r/GO1dm1/2