Re: Need Help Converting Character Sets

2012-10-01 Thread hsv
2012/09/30 11:07 -0700, Mark Phillips The data for this table comes from a web page (charet utf8). I copy/paste word files into gedit (on linux) and then copy/paste from gedit to a text boxes on the web page input form. I had thought I was stripping out all the funky characters by usin

RE: Need Help Converting Character Sets

2012-10-01 Thread Rick James
(Sorry; these are random notes, not well structured for your questions.) &#...; -- This is an "html entity". It is plain ascii, but _represents_ (in an HTML contect) some special character. Some details: http://htmltimes.com/html-special-characters.php http://www.dwheeler.com/essays/quotes-in-h

RE: NOT_REGEXP Query Help

2012-10-01 Thread John Nichel
> -Original Message- > From: Rik Wasmus [mailto:r...@grib.nl] > Sent: Monday, October 01, 2012 10:44 AM > To: mysql@lists.mysql.com > Subject: Re: NOT_REGEXP Query Help > > > I'm having an issue using regular expressions, and I was hoping > > someone can see the syntax error that I'm miss

Re: NOT_REGEXP Query Help

2012-10-01 Thread Rik Wasmus
> I'm having an issue using regular expressions, and I was hoping someone > can see the syntax error that I'm missing (Monday morning, not enough > coffee, etc). Running the following query returns the error: > > SELECT `a.custid`,`a.login` FROM ol.customers a WHERE `a.login` NOT_REGEXP > '^ano

NOT_REGEXP Query Help

2012-10-01 Thread John Nichel
Hi all, I'm having an issue using regular expressions, and I was hoping someone can see the syntax error that I'm missing (Monday morning, not enough coffee, etc). Running the following query returns the error: SELECT `a.custid`,`a.login` FROM ol.customers a WHERE `a.login` NOT_REGEXP '^anonym