List:General Discussion« Previous MessageNext Message »
From:David T. Ashley Date:July 4 2007 9:03pm
Subject:Re: How to Query by First Part of a VARCHAR?
View as plain text  
On 7/4/07, gary <byoteki@stripped> wrote:
>
> SELECT column FROM table WHERE column LIKE "CAT\_%";


Would it be reasonable to assume that if "column" is indexed, the query
would execute quickly, i.e. I would assume that the indexing would
facilitate this kind of query?

Thread
How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
  • Re: How to Query by First Part of a VARCHAR?gary4 Jul
    • Re: How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
      • Re: How to Query by First Part of a VARCHAR?Dan Nelson4 Jul
        • Re: How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
          • Re: How to Query by First Part of a VARCHAR?gary4 Jul