You can do the equivalent of “SELECT *” in RethinkDB by just selecting the table:<\/p>\n
db.table('users')\n<\/pre>\nWhich returns the data:<\/p>\n
\n\n\n\n\n\n<\/td>\n \n\nfirst_name<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nid<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nlast_name<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nuser_name<\/strong><\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n1<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n903e0943-8ffe-41ca-a22f-7b1a964b399d<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n2<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n479e9ce1-e0bb-46b3-a65f-554ac237460a<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n3<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n\n\n1b223750-799d-402a-b378-74c993a9c10c<\/div>\n<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n4<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n947a3ce6-d419-4d31-bd1e-874c721a9e6c<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\nIf you want to use a WHERE clause, you can provide a JSON payload that matches what you want, or use Javascript.<\/p>\n
The nice thing about this is you can ES6 arrow functions, so the code is fairly concise, for Javascript:<\/p>\n
r.db('test')\n .table('users')\n .filter(\n (doc) => doc('last_name').eq('sieling') \n );\n\nr.db('test')\n .table('users')\n .filter({'last_name': 'sieling'})\n<\/pre>\nThe most difficult thing to get used to is that you can’t use “===”, “>=”, etc in your Javascript, since everything is functions.<\/p>\n
\n\n\n\n\n\n<\/td>\n \n\nfirst_name<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nid<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nlast_name<\/strong><\/div>\n<\/div>\n<\/td>\n\n\nuser_name<\/strong><\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n1<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n903e0943-8ffe-41ca-a22f-7b1a964b399d<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n2<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n479e9ce1-e0bb-46b3-a65f-554ac237460a<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n4<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n947a3ce6-d419-4d31-bd1e-874c721a9e6c<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"You can do the equivalent of “SELECT *” in RethinkDB by just selecting the table: db.table(‘users’) Which returns the data: first_name id last_name user_name 1 gary 903e0943-8ffe-41ca-a22f-7b1a964b399d sieling gsieling 2 gary 479e9ce1-e0bb-46b3-a65f-554ac237460a sieling gsieling 3 test 1b223750-799d-402a-b378-74c993a9c10c test test 4 gary 947a3ce6-d419-4d31-bd1e-874c721a9e6c sieling gsieling If you want to use a WHERE clause, you can provide … <\/p>\n