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.

LAST QUESTIONS
All questions
Rent Charter Buses Company
POPULAR ONLINE
jQuery Categories

Application Freeze Android using parse Frame work small data loading

Setting yticks Location Matplotlib

php Imagick - why does it save in that folder?

Passing all recyclerview items from Activity1, into Activity2 recyclerview item

How to use ViewModel to update a TextView after EditText input in previous fragment?

READ ALSO
Trying to use the javascript variabe as php variable and store it in mysql
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
MySQL

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

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?
MySQL

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