gl2748/works.md

Created June 6, 2018 00:25

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gl2748/2f05e2f3c694d9eb59bc265534e5c3a3.js"></script>
Save gl2748/2f05e2f3c694d9eb59bc265534e5c3a3 to your computer and use it in GitHub Desktop.

mysql_wworks

Raw

            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;