lundi 16 février 2015

how to make Search query in SQLite

How to make a search query in SQLite ?


Suppose I have a table,


enter image description here


I want search in 3 fields,


If I search for string anil Hno Delhi then,


enter image description here


I tried to concatenate all 3 fields and then given a search query for that concatenated column using like but its not fulfilling my requirement.


Please Help.


Thanks


Publié par à
Libellés :

Aucun commentaire:

Enregistrer un commentaire

Inscription à : Publier les commentaires (Atom)