SQL to Flutter dart #Flutter#Firestore#dart#SQL#Query

Chaleampolpumpotong

·

Follow

1 min read

·

May 6, 2020

--

Listen

Share

import ‘package:cloud_firestore/cloud_firestore.dart’;

The SQL LIKE Operator

SELECT *
FROM table_name
WHERE columnN LIKE pattern;

var documentList = await Firestore.instance
.collection(table_name)
.orderBy(columnN)
.startAt([pattern])
.endAt([pattern+ “\uf8ff”])
.getDocuments();

SQL WHERE Clause

SELECT *
FROM table_name
WHERE columnN==pattern;

var documentList = await Firestore.instance
.collection(table_name)
.where(columnN, ==: pattern)
.getDocuments();

SELECT *
FROM table_name
WHERE columnN==patternN && columnM==patternM;

var documentList = await Firestore.instance
.collection(table_name)
.where(columnN, >=: patternN)//condition ที่ใช้ได้ ==,>=,<=,!=
.where(columnM, <=: patternM)
.getDocuments();