I created an SQLite Database for an Android application and it has been working fine so far but a specific query is returning no results. I'm completely new to SQL so if there is something trivial wrong with my query I would like to know.
SELECT word,freq FROM wordlist WHERE word = '%ras' AND dist = 2 ORDER BY freq DESC
word is varchar(4) while freq and dist are integers
the table itself has around 4000 or so four letter words and there definitely should be at least one word that satisfies the conditions of a word of the form "_ras" and dist = 2
Aucun commentaire:
Enregistrer un commentaire