How to delete records after particular position ?

Hi, Here i am again. I can select particular record by using LIMIT 9,1 But e.g. if i want to delete this record then how shall i do ? I tried to use Delete from Limit 9, 1 But i am getting erorr. pls can anybody let me know the exact syntax for this ? regards Manisha

Re: How to get the last record from the slected record set - Thanks

Thanks to all of, I could get it Thanks Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 9:52 PM Subject: Re: How to get the l

Re: How to get the last record from the slected record set

yes, but is there any better way of doing it ? regards Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 8:34 PM Subject: Re: How to get t

Re: How to get the last record from the slected record set

I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? regards Manisha - Original Message - From: "Karl Pielorz" <[EMAIL PROTECTED]> To

How to get the last record from the slected record set

I am having more than 10 records in a table. I want to select only first top 10 records (depending on one field score) and then want to select 10th position record. select * from table1 order by score desc LIMIT 10 This will give me 10 records but then how to get the last record ? Thanks in adv

Compare dates

I have a table with start_date (date), end_date (date), rate(float) as 3 fields, I want to compare today's date with start and end date if it is inside this range then pick up the corresponding rate. But how mysql stores dates ? (-MM-DD ?) how can i compare with today's date ? I tried some

Re: PASSWORD() function problem

Thanks all, it helped me a lot Manisha - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16,

Re: PASSWORD() function problem

thanks all, it works (i just increase it to 20) but one more thing, now if i want to get this password (e.g for option forget password), can we retrieve, i believe we can not- just want to confirm manisha - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To

PASSWORD() function problem

Hi, I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz using function 'PASSWORD' Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz') - then it is not getting selected I do not know why I am not getting the result. please help me