[TYPO3-core] RFC: Bug #9442: SQL LIKE wildcards are not escaped correctly for list queries

[Oliver Hader]

Hi Bernd,

bernd wilke schrieb:
> Oliver Hader schrieb am Mon, 29 Sep 2008 11:38:13 +0200:
>> I've tested the speed of the queries with 10.000 records in a table. The
>> LIKE statement finished after 13ms - the REGEXP finished after 36ms.
> 
> I have found another query with less 'likes':
> 
> WHERE (conact(',',concat(field,',')) LIKE '%,my\%Tag,%')
> or 
> WHERE (conact(',',field,',') LIKE '%,my\%Tag,%')
> (only mysql?)
> 
> can you check times for these?

I already checked this but did not write it down in the last message. 
The CONCAT() took approx 14ms and thus is as fast as the current statement.

I'm going to check this for multiple tags - maybe we could have kind of 
query strategy here.

olly
-- 
Oliver Hader
TYPO3 4.3 Release Manager