Tag: databases

RethinkDB queries let you filter on column results using a regular expression match. You can do something very similar to “LIKE”, like so:

r.db('test')
 .table('users')
 .filter( (doc) => doc('user_name').match("test") )

SQL LIKE also treats “_” as any letter – so to reproduce this behavior, you’d need to use a period instead:

r.db('test')
 .table('users')
  .filter( (doc) => doc('user_name').match("t.st") )

If you want to make this case insensitive, you’ll also want to lowercase the table data:

r.db('test')
 .table('users')
  .filter( (doc) => doc('user_name').downcase().match("t.st") )