peter korinis wrote: > A data column in a link table contains comma-separated string data, where > each value represents a value to link to another table. (many-to-many > relationship)
Every time you use non-normalized data ... God kills a kitten. > 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'? The value could appear at the beginning or in the middle or at the end or be the only value: ... id LIKE '66,%' OR id LIKE '%,66,%' OR id LIKE '%,66' OR id = '66' But please, think of the kittens! 😿 Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users