Article Preview
Buy Now
COLUMN
SQL Texting
Full Text Queries with SQLite
Issue: 8.5 (July/August 2010)
Author Bio: Paul Lefebvre has been using REAL Studio for 8 years and is the owner of LogicalVue Software, RBDevZone and a founding member of the Association of REALbasic Professionals.
Article Description: No description available.
Article Length (in bytes): 4,211
Starting Page Number: 62
Article Number: 8510
Related Web Link(s):
http://sqlite.org/fts3.html
Excerpt of article text...
One of the optional modules of SQLite is full text searching. Big deal, you say. Any database has full text searching. Just do "SELECT column FROM table WHERE column LIKE '%value%';" and you'll search the full text.
True, but this is not what we actually call a full text search and it doesn't always work the way you want it to. Let's look at this in more detail.
What is Full Text Search?
...End of Excerpt. Please purchase the magazine to read the full article.