lundi 25 avril 2016

SQLite Query is not returning results

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