Hello,

As much as I understand, MySql does not support indexes on substring selects. I have need a query like:

Code:
					SELECT 
						DISTINCT C.CODE, 
						C.NAME
					FROM 
						mtt_table1 A,
						mtt_table2 B,
						mtt_table3 C,
						mtt_table4 D
					WHERE 1
						AND (C.NAME LIKE '%abc%' OR C.KEYWORDS LIKE '%abc%')
						AND ( SUBSTRING(B.GTIP,1,4)
...