On 25 Apr 2010, at 2:44pm, flakpit wrote: > Using the first part of this query works fine to return data by searching > the multiple concatenated columns, very happy with that. > > SELECT * FROM sitelist > WHERE > sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes > LIKE '%wik%' 7 > > But I also want to AND the following columns to apply to the results and I > am not getting it (So what's new, I hear you say??) > > AND category='Bundled Software' > AND owner='Gary' > > ORDER BY sitename
Just add your AND and ORDER by clauses on after the '%wik%'. But I don't know why there's a '7' at the end of your original line. I don't think it does anything. Perhaps a typo when you made the post ? 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 Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
