search

ScientaNL / DoctrineJsonFunctions

Doctrine DQL functions for SQL JSON data type
MIT License
547 stars 50 forks source link

JSON_SEARCH missing for mariadb #86

Closed SalvatorePollaci closed 3 weeks ago

SalvatorePollaci commented 2 years ago

Hi, it seems that JSON_SEARCH function is not supported by this library even though mariadb supports it (https://mariadb.com/kb/en/json_search/).

Could such function be supported by this library?

Thanks

Hikariii commented 3 weeks ago

Almost all the mysql functions are shared between mysql and mariadb, except for (atm json_value). The syntax in the docs look the same, so Scienta\DoctrineJsonFunctions\Query\AST\Functions\Mysql\JsonSearch should be usable with mariadb also.