In SQL, you can do a fuzzy-logic kind of search. Instead of doing an exact match using the following::
 
    SELECT * FROM neighbourhood WHERE name='South Airways Park';

you can use fuzzy logic by using LIKE, with a percent sign as a wild-card::
 
    SELECT * FROM neighbourhood WHERE name LIKE '%Airways%';

This search will pick up all neighbourhoods named Airways, or South Airways, or Airways Industrial Park.

In translating this concept to SQLObject, you need to use one of three functions: startswith(), endswith() and containsstring(). Here are the SQLObject strings and their SQL equivalents::

 STARTSWITH(what, pattern)     is equiv to LIKE(what, pattern%)
 ENDSWITH(what, pattern)       is equiv to LIKE(what, %pattern)
 CONTAINSSTRING(what, pattern) is equiv to LIKE(what, %pattern%)

In addition to the above, there is also a LIKE function provided by sqlbuilder. Here is an SQLObject query using the LIKE concept::

 pkgs = Packages.select(LIKE(Packages.q.maintainerName, "%test%"))