Marcus Bointon schrieb:

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.

Well not my one though :P

But have to work with it ^^"

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

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

Reply via email to