RE: [GENERAL] non-case sensitive searches

> > > You can also use regexp expression like this :
> > > 
> > >     SELECT * FROM photos WHERE keywords ~* '.*$cat_name.*';
> > > 
> > > it works fine.
> > 
> > 
> > Thanks for the tip. Any recommendations as to which would 
> be faster when
> > searching about 2,000 records or so..
> 
> LIKE is faster, but with 2,000 records, you won't be able to tell the
> difference. It takes a blink.
> 
> --Gene

And remember unless you use full text indexing (which is expensive) you
won't have indexing on that search (for either the LIKE or regex).
	-DEJ