Re: REGEXP and INDEX

2002-02-13 Thread Matthew Dougherty
---+--+--+-+ | Companies | index | NULL | companyname_dx | 81 | NULL | 3854 | where used; Using index | +---+---+---++-+--+--+-+ 1 row in set (0.03 sec) Matthew Dougherty

REGEXP and INDEX

2002-02-12 Thread Matthew Dougherty
If I use a REGEXP query on an indexed column using something like: Field REGEXP '^A|^B|^C' Will MySQL use the index like it would if I used Field LIKE 'A%' or Field LIKE 'B%' or FIeld LIKE 'C%' ?? I could not find this info in the manual. Thanks in ad

REGEXP and INDEX

2002-02-10 Thread Matthew Dougherty
If I use a REGEXP query on an indexed column using something like: Field REGEXP '^A|^B|^C' Will MySQL use the index like it would if I used Field LIKE 'A%' or Field LIKE 'B%' or FIeld LIKE 'C%' ?? I could not find this info in the manual. Thanks in ad

Re: Problem making myodbc on Solaris 8

2001-12-04 Thread Matthew Dougherty
ompiler or make program. It may be that configure fails to succeed because "Solaris 2.8" is not one of it's options? Matt Dougherty [EMAIL PROTECTED] Matthew Dougherty wrote: > The same error occurs with 2.50.39. > > Has anyone successfully made MyODBC on Solaris8 using gcc 2

Re: compile problems on Solaris8

2001-12-04 Thread Matthew Dougherty
I hate to show my ignorance but I am unfamiliar with "SFW version of gcc that comes with Solaris 2.8". Could you clue me in? By the way, it is correct that I am using gcc 2.95.3 from the sunfreeware binary distribution. It's been a pain for several applications. (OpenSSH, etc). Matt. George

Re: Problem making myodbc on Solaris 8

2001-12-04 Thread Matthew Dougherty
The same error occurs with 2.50.39. Has anyone successfully made MyODBC on Solaris8 using gcc 2.95?? Matt Dougherty Venu wrote: > Hi, > > > -Original Message- > > From: Matthew Dougherty [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 03, 2001 11:06 AM

Problem making myodbc on Solaris 8

2001-12-03 Thread Matthew Dougherty
mysql-includes=/usr/local/mysql/include/mysql Matthew Dougherty [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Problem making myodbc on Solaris 8]

2001-11-30 Thread Matthew Dougherty
gt; --with-iodbc-includes=/usr/local/openlink/w3configu/include > --with-iodbc-libs=/usr/local/openlink/lib > --with-mysql-dirs=/usr/local/mysql/lib/mysql > --with-mysql-includes=/usr/local/mysql/include/mysql > > Matthew Dougherty > [EMAIL PROTECTED] --