Issue Feature Closed

#21902Support SQL "LOCATE"

Steffen Kamper 01/02/10, 16:10 updated 02/22/10, 22:55

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.