Re: a select n a regexp expression

2001-11-21 Thread David Devidal
- Original Message - From: "Giuseppe Maxia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 4:10 PM Subject: a select n a regexp expression > >Hello, I'm always with my access to mysql port. > >I noticve that access can dis

a select n a regexp expression

2001-11-21 Thread Giuseppe Maxia
>Hello, I'm always with my access to mysql port. >I noticve that access can dispaly a â but it s like a a. >So I make this query to select some specials row from my database : >select ort from localite_ortsnamen >where ort REGEXP "^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$"=0

a select n a regexp expression

2001-11-21 Thread David Devidal
Hello, I'm always with my access to mysql port. I noticve that access can dispaly a â but it s like a a. So I make this query to select some specials row from my database : select ort from localite_ortsnamen where ort REGEXP "^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$"=0; I