On 4 Apr 2014, at 7:20pm, peter korinis <kori...@earthlink.net> wrote:
> How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to extract > these values and use them in an SQL statement, perhaps a WHERE id='66'? This is not simple, and would lead to slow execution in a live environment. Are you willing, at this stage, to use that column to create a proper TABLE that links the two existing TABLEs, or do you need to keep the data in your database in that format, and use that column in a live environment ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users