pt-table-checksum: --ignore-tables-regex does not work properly?

2.6.32-279.14.1.el6.x86_64 I have created checksum table and tried to use --ignore-tables-regex to remove some tables from checking. pt-table-checksum --chunk-size-limit= --nocheck-plan --replicate-check --ignore-tables-regex=^test.s_.*_tmp$ --ignore-tables=test.catalogsearch_fulltext

RE: Split string by regex

ust 03, 2010 8:04 AM To: mysql@lists.mysql.com Subject: Split string by regex Hello, I'm working on a library OPAC system with books classified using the Library of Congress classification system. This takes the format of either one or two letters followed by some numbers, i.e. R272 or RA440 etc. Wh

Split string by regex

Hello, I'm working on a library OPAC system with books classified using the Library of Congress classification system. This takes the format of either one or two letters followed by some numbers, i.e. R272 or RA440 etc. What I want to do is split the field that holds this classification into tw

Re: update replace() regex

Thanks Dan, I tested it just now. It works perfectly. Dan Nelson wrote: In the last episode (Jul 08), Egor Shevtsov said: I wonder if possible at all to use replace() together with regex in update statement. I want to be able to update a field of string values and replace a '

Re: update replace() regex

In the last episode (Jul 08), Egor Shevtsov said: > I wonder if possible at all to use replace() together with regex in update > statement. I want to be able to update a field of string values and > replace a 'dash' character with a space in the string. Something like: > U

update replace() regex

Hi ALL, I wonder if possible at all to use replace() together with regex in update statement. I want to be able to update a field of string values and replace a 'dash' character with a space in the string. Something like: UPDATE table SET column = replace(column, regex '%-%&

ordering my regex

Hi all, I'm doing a "select * from comments where c.content REGEXP 'http://[^i].*'" and I would like to sort the urls found by repetition of the same urls. As an example if I get 3 records with http://google.com url in the content and two with http://mysql.com I would get the first the 3 comments

Simple Regex Question

It's been a few years since I did any regex queries, but I swear I used to be able to do something like: SELECT fieldname FROM tablename WHERE field RLIKE '(^|\|)2(\||$)'; And that would find '2', with an optional '|' at the beginning, or at the beginning

stored procedures and regex

Hi Can mysql's stored procedures do regex function -- Gregory Machin [EMAIL PROTECTED] www.linuxpro.co.za

Re: Easy regex replace?

things on the mysql command line would be very helpful ! (Instead of having a script for such simple things which would be like having a jack hammer for a nail.. ) Oh, in that case use a subselect syntax - inner one would SELECT FROM using REGEX syntax (use the fine manual, it's desc

RE: Easy regex replace?

actual value instead of a wild card. -Original Message- From: Pooly [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 5:11 AM To: MySQL General Subject: Re: Easy regex replace? 2006/3/19, Adam i Agnieszka Gąsiorowski FNORD <[EMAIL PROTECTED]>: > > On 2006-03-18, at 00:

Re: Easy regex replace?

2006/3/19, Adam i Agnieszka Gąsiorowski FNORD <[EMAIL PROTECTED]>: > > On 2006-03-18, at 00:59, Yani Copas wrote: > > > > > Is there a quick and dirty way to update such that I can only > > affect the portion > > of a string (varchar column) that matches a regexp? > > (e.g. replace all '%20' with '

Re: Easy regex replace?

On 2006-03-18, at 00:59, Yani Copas wrote: Is there a quick and dirty way to update such that I can only affect the portion of a string (varchar column) that matches a regexp? (e.g. replace all '%20' with ' ' leaving the rest untouched?) You know that proverb - "For a man in possession o

Easy regex replace?

Hi, I could write a quick script to fix the following, but just out of curiosity, if there's a quicker way to do it from the mysql command line, that'd be cool to know. I've got a few thousand rows of data that have URI escaped characters in them, and I've fixed the code that was doing it, but n

Re: Regex problem..

On Monday 25 July 2005 01:56pm, Michael Stassen wrote: > Gregory Machin wrote: > > Hi. > > > > Please could you advise me... > > I have php pages that are stored in a mysql database, that will later > > be imported into a cms > > I want to use mysql's r

Re: Regex problem..

Gregory Machin wrote: Hi. Please could you advise me... I have php pages that are stored in a mysql database, that will later be imported into a cms I want to use mysql's regex funtion to remove unwanted php code and update links to images and urls. But i cant seem to get my brian aroun

Regex problem..

Hi. Please could you advise me... I have php pages that are stored in a mysql database, that will later be imported into a cms I want to use mysql's regex funtion to remove unwanted php code and update links to images and urls. But i cant seem to get my brian around the regex part ... i wa

Re: Need help with a select. Regex?

Just a follow-up "oops"... I misread the manual page when verifying the SUBSTRING_INDEX() syntax. It states that it returns everything before _count_ instances of the delimiter, so naturally if you feed it a value that exceeds the actual instances of the delimiter, you get back the whole stri

Re: Need help with a select. Regex?

To get "http://www.google.com/"; out of the URL, you can do this: LEFT( referer, LENGTH( SUBSTRING_INDEX( referer, '/', 3 ) ) + 1 ) If you don't care about the trailing slash, you can use just the SUBSTRING_INDEX() portion: SUBSTRING_INDEX( referer, '/', 3 ) Using the LENGTH() function just help

Need help with a select. Regex?

What I am trying to do is select the hostname out of a refering url. Such as: http://www.google.com/search?hl=en&ie=UTF-8&q=%22Third+Park+Point+Beach+Water+Contact+Advisory+Posted%3B+May+Indicate+Long-Term+Problem%22&btnG=Google+Search All I really want to get is: http://www.google.com/ So I h

REGEX in an Order By clause

How do I use a REGEX expression in the Order By clause? I have a column which contains data that looks like this, A002C A001 A1000C B100AA CAR A023 I use a query like this that sorts everything but the occasional last aphla character Select field From table Order BY Left(1,field ). Right

REGEX

Do you know if there ever will be possibility to not only match with REGEXes, but also SELECT with them? Sth like SELECT REGEX(']+>', x_article.Content) FROM ... -- Seks, seksić, seksolatki... news:pl.soc.seks.moderowana http://hyperreal.info { iWanToDie } WiNoNa

Re[2]: Regex and email

Bonjour Matthew ! MS> Not sure about php syntax, but check out the perl module (in CPAN) MS> Email::Valid. I'm not searching the PHP syntax, but the SQL syntax... :) A + -- ** Richard CARLIER htt

RE: Regex and email

Hi, Not sure about php syntax, but check out the perl module (in CPAN) Email::Valid. Here is the code fragment for the regex: # Regular expression built using Jeffrey Friedl's example in # _Mastering Regular Expressions_ (http://www.ora.com/catalog/regexp/). $RFC822PAT = <<&#x

Regex and email

Hi ! I'm working on a regex to "validate" emails stored in a table. I'll try other regex from php tips or javascripts tips, but the exact syntaxe of regex in mysql are differents and nothing work fine... And I'm not very good with regex :\ I find this : SELECT

RE: REGEX

Could you maybe send us your table definition, some example data and an expected output? /rudy -Original Message- From: Doug Wolfgram [mailto:[EMAIL PROTECTED] Sent: donderdag 10 juli 2003 4:53 To: [EMAIL PROTECTED] Subject: REGEX I am familiar with regex in general, but here is what

REGEX

I am familiar with regex in general, but here is what I want to do... I have a field that contains 6 actual data items separated by the | symbol. Like this... a|b|c|d|e What I need to do is build a list of distinct values between each pipe, so that I get 5 arrays of values, one array for each

RE: Regex man page

http://www.google.com/search?q=regex+man+page > -Original Message- > From: Joe Polanik [mailto:[EMAIL PROTECTED]] > Sent: Friday, 15 February 2002 3 12 > To: [EMAIL PROTECTED] > Subject: Regex man page > > According to the online manual the regex man page contribut

Re: Regex man page

Joe, you can find it here: http://arglist.com/regex/ Peter On Fri, 15 Feb 2002, Joe Polanik wrote: > According to the online manual the regex man page contributed by Henry > Spencer is included in the source distribution of MySQL. I'm hesitant to > download > and

Regex man page

According to the online manual the regex man page contributed by Henry Spencer is included in the source distribution of MySQL. I'm hesitant to download and install a source distribution just to get a man page. Is it found anywhere else? thanks, Joseph Po

RE: Where REGEX documentation?

> Under "Description of MySQL regular expression syntax", the manual says: > > > This is a simplistic reference that skips the details. To get more exact > information, see Henry Spencer's regex(7) manual page that is include

Where REGEX documentation?

Under "Description of MySQL regular expression syntax", the manual says: This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution.

Is the MySQL regex emplementation is not standarded???

Hi, Can anyboby help me. I'm try to write a UDF which replace substring in string according regular expression. When I compile my program with -I ./../regex gcc switch I recive as result "Segmentetion fault". But when I compile my program without -I ./../regex - my program work

Re: PROJECT: for perl/sed/regex type...

see LDIF parsing. Derek Sivers wrote: > I've got a quickie project here, that's over my head, that I could pay a little >something for: > > Can you set up a script that will take flat text files, (one file per record, many >files per directory) - and do some sed/

PROJECT: for perl/sed/regex type...

I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements?

PROJECT (for perl/sed/regex person)

I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements?