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'.
2. This doesn't sound like a good DB-Design, why don't you use two seperated fields for both numbers, or a m:n table if there are more possible entries?
Definitely. Marcus -- Marcus Bointon Synchromedia Limited: Putting you in the picture [EMAIL PROTECTED] | http://www.synchromedia.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
