Structs§
RewriteLikeExprRule
rewrites like expression, so that it can benefit from index selection. col like ‘ABC’ => col = ‘ABC’ col like ‘ABC%’ => col >= ‘ABC’ and col < ‘ABD’ col like ‘ABC%E’ => col >= ‘ABC’ and col < ‘ABD’ and col like ‘ABC%E’
RewriteLikeExprRule
rewrites like expression, so that it can benefit from index selection.
col like ‘ABC’ => col = ‘ABC’
col like ‘ABC%’ => col >= ‘ABC’ and col < ‘ABD’
col like ‘ABC%E’ => col >= ‘ABC’ and col < ‘ABD’ and col like ‘ABC%E’