LIKE operator

[dm7sistemas]

How I use this example I try but I don't know
I need select using like

    dbverbs = dbQueue.inDatabase { db in
        //db_verbs.filter(Column("basename") == "be%").fetchAll(db)

        //db_verbs.filter(["be"].contains(Column("basename"))).fetchAll(db)
        db_verbs.order(Column("basename").asc, Column("past").asc).fetchAll(db)
    }

[groue]

Hello @dm7sistemas,

You want to use the LIKE operator of SQLite. And it is missing from GRDB so far: that's why you can't find it in the documentation.

I guess it should be added, yes.

Until then, use a little SQL snippet:

db_verbs
    .filter(sql: "basename LIKE ?", arguments: ["be%"])
    .order(Column("basename"), Column("past"))
    .fetchAll(db)

[dm7sistemas]

Ok, Thanks for help me. I started using yesterday !!

[groue]

You're welcome! Happy GRDB!

[groue]

In next GRDB version, you'll write db_verbs.filter(Column("basename").like("be%"))