Hi Rudy, I have to correct myself. I meant something like
...WHERE phone REGEXP '.+27-21-' Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 15:39、Nils Valentin さんは書きました: > Hi Rudy, > > > I believe you just forgot a dot here in front of the +: > > phone=".+27-21-*" > > Best regards > > Nils Valentin > Tokyo/Japan > > 2003年 8月 13日 水曜日 15:25、Rudi Ahlers さんは書きました: > > Hi > > > > I'm trying to search for some tables in a database, that contains only > > certain parts of info. I have about 3000+ records, and I'm looking for > > all the records that has +27-21, from my "phone" column, where the > > "phone" column contains phone numbers in the format of "+27-21-564 7389" > > or "+27-11-661 9000" > > > > My statement is as follows: > > select compid,company,phone from companies where (phone="+27-21-*"); > > And it doesn't return any records. What am I doing wrong? > > > > > > Kind Regards > > Rudi Ahlers > > +27(82) 926 1689 > > > > "The basic difference between an ordinary man and a warrior is that a > > warrior takes everything as a challenge while an ordinary man takes > > everything either as a blessing or a curse." > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]