search

biner88 / mysql_utils

Flutter mysql_client plugin helper, Use mysql_client easily.
BSD 3-Clause "New" or "Revised" License
13 stars 2 forks source link

Feature request - order by #2

Closed piotrszpruta closed 3 years ago

piotrszpruta commented 3 years ago

Hey, idk if its fine to ask for features there, but could you please add order by function?

biner88 commented 3 years ago

Hi, it supports order,group, and having.
getAll, getOne can use. Use like below:

var row = await db.getAll(
  table: 'table',
  fields: '*',
  order:'id desc',
  where: {'email': 'xxx@google.com','id': ['between', '1,4'],'email': ['=', 'sss@google.com'],'news_title': ['like', '%name%'],'user_id': ['>', 1]},
);
print(row);
piotrszpruta commented 3 years ago

Oh okay thanks, I think I didn't saw anything about that in docs