Re: [sqlite] comma-separated string data
Hi, Say the scenario is column value = [1,2,33,45,66] u want to compare value x with the column and retrieve data then use the condition, value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x' it should work in most of the cases (y) Thanks, Supriya -- View this message in context: http://sqlite.1065341.n5.nabble.com/comma-separated-string-data-tp74926p76757.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] comma-separated string data
Hi, Say the scenario is column value = [1,2,33,45,66] u want to compare value x with the column and retrieve data then use the condition, value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x' it should work in most of the cases (y) Thanks, Supriya -- View this message in context: http://sqlite.1065341.n5.nabble.com/comma-separated-string-data-tp74926p76758.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users