我试图在同一个表中乘以2列，并直接在laravel中的where语句中使用结果

Question

Code:

$contributions = 
  auth()->user()->cooperative->contributions->where("amount", "<", 'amount * shares');

But this doesn't return required results. How can I multiply amount and shares, they are from same table and use their products.

Answer 1

Wrap your condition in braces and it should work fine. as below:

$contributions = auth()->user()->cooperative->contributions->where("amount", "<", '(amount * shares)'); 

Hope it helps you.