Suppose I have Post model that has is_verified column with smallint datatype, how can I get all records that is verified? One thing to do this is using this: Post::where('is_verified', true)->get(); The code above will produce the following query: select…
Here is the code <?php $servername = "localhost"; $usrname = "root"; $pwd = ""; $db = "test_db"; // connect to the database $conn= mysqli_connect($servername, $usrname, $pwd,$db); if (!$conn){ die('connection failed' . mysqli_connect_error()); } // Create database $sql = "CREATE DATABASE…
I have try to create full text index. I use the " FULLTEXT KEY book_name (book_name) WITH PARSER ngram ". After created the table , the "show create table " shows that the upper line turned to be " FULLTEXT…
I want to get the records based on the row value. Please refer to the attached image for a table overview with records. If there is no Execution Project in the column projecttype for a specific ESAProjectID then take the…
I have a table for learner as learner_lesson learnerlessonid learnerid lessonid 1 24 42 and another table as learner_lesson_log lessonlogid learnerlessonid progress maxprogress. interactionType createdAt 1 1 0 15 Start 2022-11-02 07:50:30 1 1 0 15 Start 2022-11-02 07:51:30 2…
I got a little question. I would like to select N rows from 5 id. I already tried this request : SELECT a.fk_produit_id, a.id, a.titre, a.prix, a.description, a.short_description, a.image_url from produits p, articles a WHERE p.id = a.fk_produit_id AND p.fk_category_id…
Is there a way to get the N iteration of an SQL query ? For example, if I want the second iteration : Backup id id_device nb_cut 11 222 853 10 5 698 9 222 589 8 5 123 7…
Need to get record of current month but query return the wrong result.There is only one record in db.but i get wrong count for the current month $data = UserData::select( DB::raw("count(phone) as total") ) ->whereMonth('creation_date', Carbon::now()->month) ->get(); return view('kpidata', compact('data'));…
I have a column named data and I have to update its content from something like {} to [{}] for each record in table A, I tried to use JSON_ARRAY() but it gives me a quoted ["{"something": "true"}"] but I'd…
Currently I'm getting data from some sensors with voltage(V) and current(C) values which is decoded into text as V040038038039C125067 to be stored in MYSQL DB table. The voltage contains 4 different voltage values combined while the current contains 2 different…