in my table i have stored id like this
id name c_id
insert into (id,name,c_id)values( 1, john, 4,10,12,13,15)
Now i need seach id 10 avilable this row.how to write query,

Hope you clear

hi friends

I need the query , I have stored the ids like this 4,10,12,13,14 in one filed.

I need to search the id 4 avaliable in the one filed , how to search the number one single...

Yes I have checked and complete the task .Thanks for you.

Cool .Let em check and let you know any doubt

I need the query for every month , I need the query to get the values every month.

Any Idea

hi

Thanks for your reply

Table structure here

CREATE TABLE IF NOT EXISTS `invoice` (
`id` int(11) NOT NULL auto_increment,
`instance_id` int(11) NOT NULL default '0',
`project_id`...

Hi Friends

I am working to draw a graph . I need to get the data monthly, for example JAN total hours FEB total hours ,

How to write the query get the total values per month?

Advance...

is it possibrl
I need a hlp how to connect outlookexpress with mysql, so that i hav to store data from outlook express to mysql.

Why its not possibe.Please clarify

I need the same functionlity

hi friends
Try this syntax
Select * from bOrders b1 , bUsers u1 where b1.userid=u1.userid and u1.email= 'john@abc.com'

Hi friends

Please chk this query this also help for you
SELECT *
FROM applyleave a1, viewleave v1, personal p1
WHERE a1.leaveid = v1.leaveid
AND a1.spid = p1.spid
LIMIT 0 , 30

6 fields in your table but u inert only 5 values
char must be single quote

Can any one tell me what is the lastest released version (not a alpha or beta version) of MYSQL?