I'm working with a table with three columns( ID | NOTE |TAG)
ID- primary key
NOTE- some things
TAG- contains values separated with space
imagine that id-1 contains TAG- computer javaScript java forton cellphone
and id-2 contains TAG- computer java forton c++ android
When using a Wildcard to search for term java which is in middle of a string the SQLITE also shows the row containing javascript
My query " LIKE '%" + "java" + "%'";
this shows the rows if the word java is found anywhere inside (i.e) it shows java as well as javaScript as well as Scriptinjava
how to make it show only java ??
Aucun commentaire:
Enregistrer un commentaire