How to extract from a string : How can I write a query to extract something like that:

If i have John Snow or Ananana Bacarara... i want to get the results John or Ananana. 

I tried a lot of things with substr but still didn't get to a solution.. 