ID, Title, Author
1, Green Man, Frank
2, Contact, Carl Sagan
ID, Make, Model, Colour
4,Holden, Commodore, Blue
ID, Name, Address, EmployeeCount
5,Green Acres, 10 House St, 20
6,McDonalds, Featherston St, 50
How could I return the ID of rows where any of the columns is Green (assuming that 'Green' is used as a colour of a car, and 'Green' is part of a name of a company and a book
So I'd expect to returns IDs, 1, 3 and 5.
Ideally a SQL lite based sql query - but I'm assuming something like this would be cross DB and I'm not sure if you'd use the FTS extentions for this or not.