Is there a way to fetch only non-alphanumeric values from a SQLite database?
My database values has something like 23abc abc21 but I want to fetch only abc abc.
I have tried using REGEXP_REPLACE, LIKE keyword but its not working in SQLite. I want to execute this in android apps.
Try This on
String firstname1 = "23abc"; firstname1 = firstname1.replaceAll("[^A-Za-z]",""); System.out.println(firstname1);