Re: [sqlite] Search all collumns with LIKE at once

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

Re: [sqlite] Search all collumns with LIKE at once

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

Re: [sqlite] Search all collumns with LIKE at once

Martin Jenkins-2 wrote: > > fangles wrote: >> I'm currently searching through all columns in a table to see if any >> match >> the search text and the query is rather cumbersome. Is there a way to use >> a >> loop to go through all available columns by some means? Maybe a loop by >> querying

Re: [sqlite] Search all collumns with LIKE at once

Martin Jenkins-2 wrote: > > fangles wrote: >> I'm currently searching through all columns in a table to see if any >> match >> the search text and the query is rather cumbersome. Is there a way to use >> a >> loop to go through all available columns by some means? Maybe a loop by >> querying

Re: [sqlite] Search all collumns with LIKE at once

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 fangles wrote: > I'm currently searching through all columns in a table to see if any match > the search text and the query is rather cumbersome. Have you considered http://www.sqlite.org/cvstrac/wiki?p=FtsTwo Roger -BEGIN PGP SIGNATURE-

Re: [sqlite] Search all collumns with LIKE at once

fangles wrote: I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? If you had a PK on that table and

Re: [sqlite] Search all collumns with LIKE at once

fangles wrote: I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? SELECT * FROM addresses WHERE title

[sqlite] Search all collumns with LIKE at once

I'm currently searching through all columns in a table to see if any match the search text and the query is rather cumbersome. Is there a way to use a loop to go through all available columns by some means? Maybe a loop by querying the schema? SELECT * FROM addresses WHERE title LIKE '% +