How to compare BigInt and Varchar values in Laravel 5.4 and Mysql

233
December 18, 2017, at 5:10 PM

I have a query something like this,

 ->where('qlog.data2','=', 'oreka.orktape.duration') 

qlog.data2's type is varchar and other one bigint. how to compare these two types using laravel Eloquent.

Rent Charter Buses Company
READ ALSO
Trying to use the javascript variabe as php variable and store it in mysql

Trying to use the javascript variabe as php variable and store it in mysql

I have two JS variables I want to use them as php variables and store them in the databaseHere is sample

146
Delphi mysql datetime plus minutes subtract current time

Delphi mysql datetime plus minutes subtract current time

I am trying to create a countdown timerI have created_at value, life_time value and current_time

346
MySQL conf file in MySQL docker

MySQL conf file in MySQL docker

I am running MySQL 57

327
How do i display random values from an sql database onto my html website which change when i click a button?

How do i display random values from an sql database onto my html website which change when i click a button?

Basically, I want to create a website where data is input to a database (which I've figured)but my problem is as such: there's a field in my database called namesFrom that field I want to select a random name when the user clicks a button

202