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
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:25Rudi 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
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 trying
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:39Nils Valentin :
Hi Rudy,
I believe you just forgot a dot here in front of the +:
phone=.+27-21-*
Best regards
Nils Valentin
[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, use