#21902Support SQL "LOCATE"
Description
the LOCATE function isn’t supported in DBAL.
In templavoila i added this in select clause:
CASE WHEN LOCATE’, ‘tx_templavoila_tmplobj’) . ‘, datastructure)>0 THEN 2 ELSE 1 END scope
Syntax of LOCATE:
LOCATE(needle, searchinstring)
Result is the position of needle, simular to php “strpos”
Simular would be following SQL functions:
POSITION, INSTR, SUBSTR, SUBSTRING, SUBSTRING_INDEX etc,
see http://dev.mysql.com/doc/refman/5.1/en/string-functions.html
(issue imported from #M13134)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.