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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]