Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 8.5

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.