Question: ![enter image description here](https://i.stack.imgur.com/WXi5v.jpg)

I have a bit attribute called 'tobacco' in tblVisits. tblICD is a list of medical codes and icd\_jxn is the junction table. tblICD.Descrip is a text description of the medical code (ICD\_ID). I'm trying to see if anyone who does `NOT` have the string 'tobacco' in their list of medical codes has their `bit` 'tobacco' attribute set to one. The query below is my best guess, but it's not correct. 

```
SELECT tblVisits.kha_id, tblVisits.tobacco from tblvisits
WHERE NOT EXISTS (SELECT icd_jxn.kha_id, icd_jxn.icd_fk, tblICD.icd_id, tblICD.Descrip
                   FROM icd_jxn inner join 
                        tblICD on icd_jxn.icd_fk = tblicd.icd_id
                       WHERE (tblicd.descrip like N'%tobacco%') AND (tblVisits.kha_id = icd_jxn.kha_id) and (tblvisits.tobacco=1))

```

Answer: 
Redis is a fast key-value store which is great for something like session. I see a lot of MongoDB with Mongoose in the community but I am more of a CouchDB person myself.

If you like learning new stuff you can try a few of them and see which one you like. If you have a deadline and you know MySql I would just stick with that for now.
MongoDB is a good choice. I'm a huge fan of [Redis](http://redis.io) myself (even for a small, everyday DB).

If you don't need an ORM type modeling for your data, I suggest [MongoJS](https://github.com/gett/mongojs) or [Mongoskin](https://github.com/kissjs/node-mongoskin). They both make it really easy to interface with MongoDB with very little code.