i'd so
select compid,company,phone from companies where MATCH (phone) AGAINST
('+27-21-*', IN BOOLEAN MODE); something like thatis it your number in particular or stuff similar to that ? you could also try select compid,company,phone from companies where phone REGEXP "+27-21-" > 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." > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
