mysql: reversed content col for LIKE '%foo' - good practise?
- by Haroldo
I was recently watching a google lecture on mysql and learnt that MySQL wont use indexes for LIKE '%foo' searches.
My site's 'live search' (ajax search) searches the column full_details(TEXT), should i create a reversed version like full_details_rev(TEXT) and index that?
Or should i not index large text fields at all?