Editing rows in a column

I have a column that contains Action Name. It has data like Login, Logout, People Search etc. 

Action Name

Login

Logout

People Search with $$$$$$$$$$$$$4

People Search with  00000000

People Search with 

etc.

I have 10000 rows.

I want to just keep people search and delete the rest. Is there a way to do it. I am connected to live data and do not wish to make any changes there.