Anyone any good with sqlite?

[ChrisL]

I want to do a search for a string but I don't want to specify a column to search.

Is this possible?

SELECT * FROM Persons WHERE "any column"='Sandnes'

At the moment I'm getting all rows and doing a stringinStr() for each row but I'm hoping I can do it with the sql statement instead.

Thanks

Chris

[CrewXp]

Granted your table and database names are correct, that's the correct syntax to use in sql.

[sandyd]

I would imagine that your will have to structure your query for all Columns, e.g.

SELECT * FROM Persons WHERE (Column1 = 'Sandnes') or (Column2 = 'Sandnes') or (Column3 = 'Sandnes') ...

Thats how I would do it in any other SQL database

[ChrisL]

Thank you, you are correct I seem to have to specify each column name with the OR statement