Home > other >  In Sqlalchemy query, how to use like regular query?
In Sqlalchemy query, how to use like regular query?

Time:04-07

Such as in the following sentence
Q=query (opt) OPT_DAILY_PRICE)) filter (
Opt. OPT_DAILY_PRICE. Code. Like (' C %), # choose code begin with SR in mark, detailed view query tutorial
Opt. OPT_DAILY_PRICE. Date=='2019-07-02' # specified date is equal to the 2019-07-02
(opt). Order_by. OPT_DAILY_PRICE. Date. Desc () # according to date
). The limit (10)
Opt. Run_query (q)
I hope like choose C followed by three arbitrary number of items, how to construct the format?
  • Related