Re: [GENERAL] Can LIKE use indexes or not?

[John Sidney-Woollett]

John Sidney-Woollett said:
> select * from t where new_upper_f like upper('MMM%');

I think I meant

select * from t where new_upper_f like 'MMM%';

or

select * from t where new_upper_f like upper('mmm%');

John



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend