I just come a cross the case of a like
in a query for InfluxDB. InfluxDB doesn't have like exactly but there is something simular. It resembles more a pattern matching than like
.
This will return all records containing "2020-12-22T" in "cashout_time".
SELECT "payout" FROM "hive_upvotes"
where "cashout_time" =~ /2020-12-22T*/
This is the oppiste of the first query. It will return all records not containing "2020-12-22T" in "cashout_time".
SELECT "payout" FROM "hive_upvotes"
where "cashout_time" !~ /2020-12-22T*/