Martin Jenkins-2 wrote: > > fangles wrote: >> PK? I'm sorry but I am not familiar with that term.. > > Sorry, in this example a Primary Key is a column (eg an integer) which > uniquely specifies a row in a table. > > In the example above you: > > select all columns from the rows which have a PK in the set > ( > select the PK from all rows where the columns joined together > matches your search text > ) > > BTW, I don't know how well this performs compared to the FTS extensions. > > Martin > > Thanks Martin, the acronym threw me originally LOL. I'd have to redesign the original database to do FTS so your way using PK seems easier for now. -- View this message in context: http://www.nabble.com/Search-all-collumns-with-LIKE-at-once-tf3251161.html#a9040441 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
