Closed ejball closed 3 years ago
column LIKE 'prefix%' is a common operation that can be implemented efficiently by database engines but is hard to get right with an arbitrary prefix, especially if the prefix might have wildcard characters that need to be escaped.
column LIKE 'prefix%'
column LIKE 'prefix%'
is a common operation that can be implemented efficiently by database engines but is hard to get right with an arbitrary prefix, especially if the prefix might have wildcard characters that need to be escaped.