彭一凡 schrieb: > try this: > WHERE concated_field LIKE '87682%' > or > WHERE concated_field LIKE '87682<next>_____' > would give me 876825 what i am not looking for. And i were also looking for <next>87682.
So this doesn't work. But thanks anyway :) -- 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]