flakpit wrote: >> SELECT * FROM sitelist >> WHERE > sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes > LIKE >'%wik%' >> AND category='Bundled Software' >> AND owner='Gary' >> ORDER BY sitename > > Hello Simon, that's what I tried first (yes, the '7' was a typo, sorry) and > it didn't work.
Define "didn't work". What results did this query return, and how do these results differ from your expectations? > it is not giving me any results at the moment. Well, do you actually have any records that match all the conditions? Show a sample of your data; in particular, show the record that you believe should be returned by the query. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
