title: How can i use the querystring for knex?
body: <pre><code>router.get("/stocks/symbols", function (req, res, next) {
    req.db
      .from("stocks")
      .select("name","symbol","industry")
      .modify(function(queryBuilder) {
        if (req.query.param) {
            queryBuilder.where('industry',req.query.param);
        }
    })
      .where('timestamp', '=', '2020-03-24T00:00:00Z')
      .then((rows) =&gt; {
        res.json(rows)
      })
      .catch((err) =&gt; {
        console.log(err)
        res.json({ Error: false, Message: "Error in MySQL query" })
      })
  })
  </code></pre>
  
  <p>I'm trying to make such a functionality to use querystring.
  At the moment this runs without error but doesn't do anything.
  Whether I put ?industry=h or anything after the route, it returns the same data.
  There was an example I followed, but for some reason its not working.
  What else am i missing?</p>
  
  <pre><code>router.get("/stocks/symbols/:industry", function (req, res, next) {
    req.db
      .from("stocks")
      .select("name","symbol","industry")
      .where('timestamp', '=', '2020-03-24T00:00:00Z')
      .where("industry", "like", `%${req.params.industry}%`)
      .then((rows) =&gt; {
        res.json({ Error: false, Message: "Success", Cities: rows })
      })
      .catch((err) =&gt; {
        console.log(err)
        res.json({ Error: true, Message: "Error in MySQL query" })
      })
  })
  </code></pre>
  
  <p>This does similar job that i want to do but it doesn't use the querystring.</p>