The SQL LIKE operator is accessed by the like() method of a field:
db(db.category.name.like('d%'))
considers only categories starting with d.