General developer forum

Security Overview Report issue

 
Picture of Darko Miletić
Re: Security Overview Report issue
Core developersParticularly helpful Moodlers

What database are you using?

In any case SQL LIKE and OR does not work well especially with MySQL.

In case you do use MySQL and it happens to be 5.6.4 or more recent you can add fulltext indexes and rework queries to use that. See this document

https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html

and this one

https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html#function_match

 
Average of ratings: -