Barry wrote:
Hello everyone!
I have a slight problem matching rows.
My problem is the Value in a textfield is: "87682<next>39857"
I created that with concat.
Is there a way to match one specific number out of that field?
like WHERE SUPERFUNCTION(concated_field) = 87682
WHERE concated_field LIKE '%87682%'
See: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
BTW:
1. The performance of LIKE is not that good :-S
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?
Is something like that possible in any way?
Or does something like that function exists?
Well in PHP you a function called in_array() which would work kind of
similiar what i want to do.
Any help is very appriciated ^_^
Many thanks for any replies
Barry
HTH,
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
