vendredi 27 février 2015

Android Sql Like

I'm using SQLite for my database and what I need is get the list of the username based on a specific string


My query is



SELECT * FROM username_table WHERE username like 'john[^0-9]%'


Results are:



john1, johnny12, john123, johnatan12 ... (Except john I dont know why)


What i need is only john or john with any number besides him


Expected Result



john, john012, john1245, john1, john46...


Thank you


Aucun commentaire:

Enregistrer un commentaire