2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by Stefano Mtangoo
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.