[EMAIL PROTECTED] wrote:
> select compid,company,phone from companies where MATCH (phone) AGAINST
> ('+27-21-*', IN BOOLEAN MODE); something like that
'something like that' triggered me ... try
select compid,company,phone from companies where phone LIKE '+27-21-%';
IIRC LIKE will, as a bonus, us
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
>
>
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+ r
i'd so
select compid,company,phone from companies where MATCH (phone) AGAINST
('+27-21-*', IN BOOLEAN MODE); something like that
is 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 try
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-66
