Posted by hardik on 10/16/06 07:48

hi friends i need help in this sql query

i have table like,

id fid
__ _____
autonumber text

and i am storing values like

id fid
___________________________________
1 1,2,3,4,5

2 11,12,13,14,15

now to find values i am using query

sql = SELECT * FROM test12 WHERE `fid` LIKE ('%1%')

only problem in this query is it is selecting 1 and 11 and i require
only 1 as i am giving one in %1%
now any one have answer of this question then plz plz tell me ........

• Next in forum: Re: Date overlapping
• Prev in forum: can anyone solve this sql query?
• Thread view: can anyone solve this sql query?

[Reply to this message]