Not all databases support REGEXP as an operator.
LIKE is either case-insensitive, or can be made so with a
(database-specific) operator on most databases.
Moreover, LIKE can often take advantage of indexes.
Consider for PostgreSQL:
x ILIKE 'SENT' OR x ILIKE 'SENT_ITEMS'
Consider LIKE for SQLITE and MySQL:
x LIKE 'SENT' OR x LIKE 'SENT_ITEMS'
On my system, LIKE/ILIKE is almost twice as fast as REGEXP, and I doubt
it's linear.
Also, on my PostgreSQL 7.4 machine, it doesn't even support that REGEXP
syntax- but instead "x ~ 'SENT'" works...
On Tue, 2006-06-06 at 12:50 -0700, Aaron Stone wrote:
> On Tue, 2006-06-06 at 23:30 +0400, Oleg Lapshin wrote:
>
> > May be select must be in such form:
> >
> > mysql> SELECT mailbox_idnr,name FROM dbmail_mailboxes WHERE BINARY name
> > REGEXP '^[sS][eE][nN][tT]$' AND owner_idnr='2';
>
> Oh duh, that should do it!
>
> Aaron
>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
--
Internet Connection High Quality Web Hosting
http://www.internetconnection.net/
