Problem with regexp

).groups() ('(OT)',) But in MySQL, I don't match: mysql select 'This is an (OT) Test' regexp '[\(][Oo][Tt][ \]\)]' as mtch; +--+ | mtch | +--+ |0 | +--+ 1 row in set (0.00 sec) Can anyone see the problem here? ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch

Re: Problem with regexp

On Feb 28, 2004, at 10:33 AM, Michael Stassen wrote: In the meantime, perhaps the following will help: mysql select 'This is an [OT] Test' regexp [ [:punct:]]OT[ [:punct:]] as mtch; Hey, thanks - that works! ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: Newbie Question

. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sloooow sql query

on the `date` field? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL2000 and MySql

of the fastest engines for local manipulation of data. I frequently use Visual FoxPro to grab data from a MySQL database, make the updates locally, and then pump the changes back. VFP rocks with MySQL! ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com

Re: SQL2000 and MySql

way of doing things. There is a large group of developers who develop business apps for Windows desktops in VFP, and use MySQL on Linux servers for the data. At a recent VFP conference, a session on using MySQL was packed. ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: SQL2000 and MySql

of MySQL for a couple of milliseconds of improved performance. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: transaction support

suspicious of anyone who tailors a solutions to his needs instead of yours. I'd not only consider using MySQL, I'd consider looking for a different developer. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General

Re: Oracle nvl function equivalent.

is called IFNULL(). ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Roles

. It is then a matter of joining the person table to the role table through the allocation table to get a list of all roles for a given person. Reversing the queries then gives you all people who have a given role. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more

Re: Forms Reports like I use in MS Access

will chime in with. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT Optimization (speeding up a SELECT)

trying to find a single percent sign? ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing Mysql on Panther

Preferences, and turn off Web Sharing in the Sharing preference pane. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: changing the case of data

?? UPDATE MyTable SET MyField = LOWER(MyField) ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Index before or after inserts?

, then index. Otherwise, the indexes have to be updated with each and every insert. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: SHOW TABLE STATUS without LIKE

functionality). So as long as the list admins configure the list this way, you have to expect a large number of these sort of problems. It's their choice to fix it or not. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL

Re: How do test unique values in a MySql column?

in the table: SELECT txtName FROM MyTable GROUP BY txtName HAVING count(*) = 1 ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: secure automated access (was Re: Backing up all databases)

. Removing them so that the entry reads: [client] password=mysql_root_password will correct the problem. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: secure automated access (was Re: Backing up all databases)

were only to be used when the password contained comment characters. I'm using 4.1.0-alpha running on RH *, if that makes any difference. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives

Re: Convert Foxpro database to Mysql

On Saturday, October 4, 2003, at 11:05 AM, Dwi Suharto Panese wrote: i want to convert the existing foxpro database into mysql database. Any idea? Sure, I've done it a lot. What exactly do you need to know? ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: Like MySQL Dump, but with FoxPro Tables

___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 1000 rows in MySQLcc

queries. The 1000 limit only kicks in as a default. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Text fields

how do i append text to a field. (I can tune server parameter max_allow_packet , but that's not a good option) update mytable set textfield = textfield + newchunk where pk = [ your pk ] ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General

Possible regexp bug in 4.1a?

| +---+---+--+--+--+-+ 1 row in set (0.37 sec) I've tried variations on this query, and it seems that nesting two functions as the argument to regexp causes the match to fail. Am I missing something obvious, or should I report this as a bug? ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: Select match from a stored delimitated string?

a given piece belongs to. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how listen queue size affect MySQL on RedHat

, I've read the dire warnings about munging Reply-To: headers, but none of them make any valid points. I've run and participated in many lists, and have never had a problem with defaulting replies to the list. ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: INDEX'd fields...any drawbacks?

. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Working with the text datatype in Mysql

the net but couldn't find more information about what might be causing the problem... How are they typing in the information? From a web page? From the command line? From a custom program? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General

Re: does mySQL support a boolean data type?

to cut down on the storage. I use tinyint, and populate the fields with either 1 or 0 for True and False, respectively. This translates well to languages such as Python, which also use 1 and 0 to indicate boolean states. ___/ / __/ / / Ed Leafe http://leafe.com/ http

Re: What's up with this GATOR crap?

-back installation to 3rd parties, many of which install spyware, and Gator is one of the most common. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Stuck with Tutorial

On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote: SELECT * FROM pet WHERE birth = 1998-1-1; Try: SELECT * FROM pet WHERE birth = 1998-01-01; You need 2 characters for the day and month fields. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com

Re: very long query time

java programs. Perhaps telling us what the query is might help with a solution. Adding the proper index might speed things up dramatically; sometimes re-wording the query can also help. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General

Re: Full text search

' appears anywhere in the field. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySQL GUIs

On Thursday, June 12, 2003, at 10:44 AM, Justin wrote: Anybody have any recommendations for one that runs on Mac OS X? I use phpMyAdmin to manage several MySQL databases, both on my LAN and over the internet. Way cool and powerful! ___/ / __/ / / Ed Leafe http://leafe.com

Re: Doing a count of a count in mysql

that for each count, and join the statements with UNION. For more than a few possible counts, though, I'd probably use a temporary table, and do a second select from that. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list

Where is the COMPRESS() function?

? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]