Query...Urgent

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For lis

Query. Urgent!

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For lis

Re: A difficult query- urgent for me

2006-01-15 Thread Rhino
To: Sent: Sunday, January 15, 2006 10:21 AM Subject: A difficult query- urgent for me Dear Friends, I have a problm, try to solve that. Actually there is a table with columns a and b . So i want if a contains a particular word than a's value should return else 'b' value should re

Re: A difficult query- urgent for me

2006-01-15 Thread Jochem van Dieten
On 1/15/06, [EMAIL PROTECTED] wrote: > > Actually there is a table with columns a and b . > So i want if a contains a particular word than a's value should return else > 'b' value should return. SELECT CASE WHEN a = 'Good' THEN a ELSE b END FROM table Jochem

A difficult query- urgent for me

2006-01-15 Thread [EMAIL PROTECTED]
Dear Friends, I have a problm, try to solve that. Actually there is a table with columns a and b . So i want if a contains a particular word than a's value should return else 'b' value should return. And there must be one and only one column returning. I have mysql 4.x and i think the logic will be

Re: mysql query urgent!!!

2001-06-12 Thread Bob Hall
>i, >I have to write simple mysql script. I need folowing things: > >Number of people logged in previous 0 to 24 hours >Number of people logged in previous 24.5 to 48 hours >Number of people logged in previous 48.5 to 72 hours >Number of people logged in previous 72.5 hours to 7 days >Number of pe

mysql query urgent!!!

2001-06-12 Thread Kapil Sharma
i, I have to write simple mysql script. I need folowing things: Number of people logged in previous 0 to 24 hours Number of people logged in previous 24.5 to 48 hours Number of people logged in previous 48.5 to 72 hours Number of people logged in previous 72.5 hours to 7 days Number of people log