Search with PHP/SQLite

[Stefano Mtangoo]

I have tables already. How do I search for a given keyword?
Thanks

[digital-ether]

Simplest, a normal select or you can use the "like" keyword.
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
However, for more efficient searching you want to create an index, either just a database index (like fulltext, or manually creating the index tables and indexing all columns), or an optimized search index such as an inverted index. http://en.wikipedia.org/wiki/Inverted_index

Note the link to mysql is because the SQLite syntax is the same.

[Stefano Mtangoo]

Thanks digital-ether
I will check