note
runrig
Well, you could say:<code>
where name like ? || '%'
</code>
But that still won't use an index on the column since the query optimizer doesn't know where any other wildcard will be, whereas hardcoding the entire argument might use an index:<code>
where name like 'abc%'
</code>
1039600
1039606