Re: Using REGEXP

[Harald Fuchs]

In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:

> SELECT t1.*
> FROM ytbl_development t1
> INNER JOIN tmpShortCodes sc
> ON INSTR(t1.txtDevPostCode, sc.short_code) =1

This is the same as

  SELECT t1.*
  FROM ytbl_development t1
  INNER JOIN tmpShortCodes sc
  ON t1.txtDevPostCode LIKE concat(sc.short_code, '%')

and this query would use indexes on txtDevPostCode and short_code.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]