var caseSensitive = false;
var findTerm = 'mozilla';

var statement = dbConnection.createStatement(
   'SELECT title, url FROM moz_places '+
   ' WHERE visit_count > 0 AND'+(
      caseSensitive ?
        'title GLOB ?1 OR url GLOB ?1' :
        'title LIKE ?1 OR url LIKE ?1'
   )
  );
try {
  statement.bindStringParameter(0,
    caseSensitive ?
      '*'+findTerm+'*' : // for GLOB
      '%'+findTerm+'%' // for LIKE
  );
  while (statement.executeStep()) {
    var title = statement.getString(0);
    var url   = statement.getString(1);
    alert(title+'\n'+url);
  }
}
finally {
  statement.reset();
}