Android query to extract first word from a field

So I've been dragging with this on开发者_如何学运维e for some time now and simply can't find the solutions

Let's say I have a table called NAME with values like John Doe Jane Doe etc.

I just want to pull the first word.... so everything after the first space ' ' will not show I'm pulling the data into a Cursor as it's over 2000 records

Any thoughts on a raw query that will do such a thing? Thanks in advance Yeshai

---

You just get the string from db as a string and use something like

String[] strs = dbString.split(" ");

str[0] should be what you need.