search

Tencent / wcdb

WCDB is a cross-platform database framework developed by WeChat.
Other
10.61k stars 1.39k forks source link

请问 SELECT * from `models` where `id` in (26612,26611,26610) order by field(id,26612,26611,26610); OderBy 部分怎么转化呢 #1118

Closed LinglongKK closed 2 weeks ago

LinglongKK commented 2 weeks ago

The language of WCDB

Swift

The version of WCDB

v2.1.2

The platform of WCDB

iOS

The installation of WCDB

Cocoapods

What's the issue?

implement sql -> "SELECT * from models where id in (26612,26611,26610) order by field(id,26612,26611,26610)"

how to convert order by statement

Qiuwen-chen commented 2 weeks ago

Is it a valid sql for sqlite?

LinglongKK commented 2 weeks ago

Sorry , the field function is a syntax supported by MySQL.