Marcus Bointon wrote:
On 9 May 2006, at 14:27, Wolfram Kraus wrote:WHERE concated_field LIKE '%87682%'No, because that would also match numbers that contain that sequence like '187682<next>32876825'.
WHERE concated_field LIKE '87682<%' OR concated_field LIKE '%>87682' Still poor performance ;-) [...]
Marcus
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]