TYPO3 Core

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
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)