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]

Reply via email to