Skip to content

Instantly share code, notes, and snippets.

@gl2748
Created Jun 6, 2018
Embed
What would you like to do?
mysql_wworks
            case 'fingerprint':
            debugger
                /* Does not work
                andList.push(
                  sequelize.query("SELECT * FROM `users` WHERE JSON_EXTRACT(fingerprint, '$.ref') = 'https://jsfiddle.net/' " , { type: sequelize.QueryTypes.SELECT})
                )
                */
               //User.findAll({
                //where: {
                  //$and: [
                    fingerprint: {
                      sequelize.where(
                        sequelize.literal('fingerprint->"$.ref"'),
                        "https://jsfiddle.net/"
                      )
                    }
                  //]
               // }
              //});
            break;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment