On Sun, 8 Nov 2009 10:31:05 -0500 "Igor Tandetnik" <itandet...@mvps.org> wrote:
> > SELECT * > > FROM fm > > WHERE name LIKE '%Juiian%' > > AND info LIKE '%' || name || '%' > > ORDER by name; > > Thanks for seeing the oversight. When I use SELECT * FROM fm WHERE name LIKE '%Julian%' OR info LIKE '%' || name || '%' ORDER by name; it returns 224 columns. Perhaps I'm misunderstanding the concept. It could be returning 5 columns with 'Julian' AND all columns where column 'name' is LIKE column info. That would be a whole lot more. Ted _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
