First, take a look at this table, basically I need to UPDATE (+1) a ticket WHERE the Username equals to Jondoe AND Money is greater than 200.
Now, I know I can execute 3 queries, first to check if the actual user has Jondoe as Username, then check if he has enough Money and if these results are true, then UPDATE (+1) a ticket finally.
I'm learning SQL and i'm working over a mssql database, what's the proper way to do such a conditional query/update? Can I avoid using that many queries?
I'm also working with laravel framework, I don't know if it comes with any "tool" to accomplish what I want.
Thanks in advance
Laravel has the fluent query builder which you can use (more or less) like below:
$affectedRows = DB::table('TableName') ->where("Username", "Jondoe") ->where("Money",">",200) ->increment("Tickets");
You can also use
$affectedRows to check if there were any updates made.