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