ReturnReturn to Article

Recommend Tuning Leading '%' Queries - a simple approach (Email)

This action will generate an email to the person below recommending this article. Your email address, and the email address of the person you are sending this article to, are not logged by our system.

EmailEmail Article Link

The email sent will contain a link to this article, the article title, and an article excerpt (if available). For security reasons, your IP address will also be included in the sent email.

Article Excerpt:

Hi reader,

usually queries using LIKE and leading '%' cannot be indexed. So an idea would be to mirror the string content with the string reverse function to be able to put the '%' operator at the end :


Article Link:
Your Name:
Your Email:
Recipient Email:
Message: