List:General Discussion« Previous MessageNext Message »
From:Sivasakthi Date:July 24 2008 4:04am
Subject:Re: WHERE .... IN
View as plain text  
>
> How about:  WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR
> field1 LIKE '%,123' OR field1 = '123' )
>
> Note that this could that a long time on large tables.  You'd be better
> off to normalize your tables ;)
>   
How can we normalize the tables? could you explain bit more?


Thanks,
Siva
Thread
• WHERE .... INAli Deniz EREN23 Jul
  • Re: WHERE .... INPeter Brawley23 Jul
  • Re: WHERE .... INMr. Shawn H. Corey23 Jul
    • Re: WHERE .... INSivasakthi24 Jul
      • Re: WHERE .... INMr. Shawn H. Corey24 Jul
  • Re: WHERE .... INJohan Gant24 Jul