LIMIT in query
fredmjf | Posted 2:55pm 31. May 2009 Server Time |
Hello,
I have the following asp-query problem:
When i used an access database i had this query:
SELECT TOP 1 * FROM TblUsers Where UserId=" & oItems("UserId")
Now i'm over to mysql but the query isn't good. It lookes like i'll have to use LIMIT 1 in place of TOP 1 but how and where must i'll put it in the query??
Fred |
katy8439 | Posted 4:31am 1. June 2009 Server Time |
"SELECT * FROM `your_table` WHERE UserID = "&oItems("UserID")&" LIMIT 0, 1"
Should show only the first record
Katy
Reply to Post LIMIT in query
|
|
|
