Looping within dataset

[priya_s]

@bghayad, Refer following link -

How to use like operator in frappe.db.sql

I have a item_group like 000 Now, I want to use Like Operator in frappe.db.sql My query is SELECT tabItem.item_code as “Item Code”,tabItem.name as “Item Name” FROM tabItem WHERE tabItem.item_code LIKE ‘000%%’ ORDER BY name desc limit 1;