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