>A text field -Lets call it 'field1'- contains datas seperated by
commas(,)
> like this (123,5764,8795,9364,11,232,.....
The solution is to normalise the data.
PB
Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
commas(,) like this (123,5764,8795,9364,11,232,..... and go on) And so
my lines like these:
id title filed1
-------------------------------------------------------------
1 title1 123,576412
2 title2 123
3 title3 576412,8795,123
4 title4 123
5 title5 576412,1164,12,232
.. ... ...
.. ... ...
I am looking for lines which includes the matched value within the
field1 seperated case. For example:
"SELECT id, title, field1 FROM mesaj WHERE 123 IN (field1)"
result is.
1 title1 123,576412
2 title2 123
4 title4 123
But I want it to match with third one.
3 title3 576412,8795,123
Because it have a 123 at the end. But It does not! :(
Is there another way to do this. LIKE doesn't work because
"SELECT id, title, field1 FROM mesaj WHERE field1 LIKE 12" returns
many result which is not my intention.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
