$database->rand not working

[syntax-error-1]

Information

• Version of Medoo: 2.1.1
• Type of Database (MySQL, MSSQL, SQLite...): MySQL 8.0.8
• System (Liunx\Windows\Mac): Windows

Describe the Problem

A clear and concise description of what the problem is.
$database->rand(); was working properly in the older version of mysql but after I updated my MySQL and php to version 8, the
rand function has stopped working.

Detail Code

$data = $database->rand("users", [
	"email"
], [
	"user_id[>]" => 1
]);

Expected output

Here is the error i am getting :
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION likesblast.NEWID does not exist in D:\Xampp\htdocs\likesblast\Medoo.php:563 Stack trace: #0 D:\Xampp\htdocs\likesblast\Medoo.php(563): PDOStatement->execute() #1 D:\Xampp\htdocs\likesblast\Medoo.php(1593): Medoo\Medoo->exec(Object(PDOStatement), Array) #2 D:\Xampp\htdocs\likesblast\Medoo.php(1988): Medoo\Medoo->select('users', Array, Array, NULL) #3 D:\Xampp\htdocs\likesblast\classes\test.php(9): Medoo\Medoo->rand('users', Array, Array) #4 {main} thrown in D:\Xampp\htdocs\likesblast\Medoo.php on line 563

[catfan]

What's the code you actually called? What's the output of debug()?

NEWID() will be called if you set the database type as MSSQL. https://github.com/catfan/Medoo/blob/master/src/Medoo.php#L1974

Are you sure you set the database type to mysql correctly?

[syntax-error-1]

Output of debug :

SELECT emailFROMusersWHEREuser_id > 1 ORDER BY NEWID()

And I have set the database to mysql, please check the code below :

`<?php

require '../Medoo.php';
// Using Medoo namespace
use Medoo\Medoo;

$database = new Medoo([
// required
'type' => 'mysql',
'database' => 'likesblast',
'host' => 'localhost',
'username' => 'root',
'password' => '',
]);

$data = $database->rand("users", [
"email"
], [
"user_id[>]" => 1
]);
var_dump($data);
?>
`

[catfan]

Thanks for the feedback.

It fixed on 5f8f9f1.

[syntax-error-1]

Thanks , it is working now .