Why doesn't the JSON_CONTAINS function work in MariaDB?

Question

MariaDB

Here is an example sql query:

$this->db->query("SELECT * FROM `" . DB_PREFIX . "custom_fields_option` WHERE JSON_CONTAINS(option_in_show, '{\"id\":\"15\"}')");

It gives me an error that there is no such function, version 10.1.25-MariaDB

Answer 1

JSON functions were added in MariaDB 10.2.3.

https://mariadb.com/kb/en/json_contains/