On 20-6-2019 08:11, Michael Falconer wrote:
SELECT peace FROM disaster WHERE disaster.cause = 'Windows';
Returns: *nix
The query should be
SELECT peace
FROM disaster
WHERE (disaster.cause LIKE '%Windows%'
OR disaster.cause LIKE '%nix%'
OR disaster.cause LIKE '%incompetence%'
);
Also then return value might be different, depending on the time of day
and possible other, at present not known, parameters.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users