Get only first row mysql

/**
To return only one row use LIMIT 1:
**/

SELECT *
FROM tbl_foo
WHERE name = 'sarmen'
LIMIT 1

/**
It doesn't make sense to say 'first row' or 'last row' unless you have an ORDER BY clause.
Assuming you add an ORDER BY clause then you can use LIMIT in the following ways:
To get the first row use LIMIT 1.
To get the 2nd row you can use limit with an offset: LIMIT 1, 1.
To get the last row invert the order (change ASC to DESC or vice versa) then use LIMIT 1.
**/

Source: stackoverflow.com

Similar codes

0 vote278 views1 answer
Rows, INSERT INTO, Returning
SQL
5 votes252 views1 answer
Oracle generate list of dates in between a date range
SQL
5 votes246 views4 answers
Sql check
SQL
1 vote220 views1 answer
Full text index mysql
SQL
0 vote266 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote314 views1 answer
How to check all scheduled jobs in oracle
SQL
3 votes243 views2 answers
Mysql HAVING
SQL
0 vote256 views1 answer
Mysql multiple group by
SQL
0 vote285 views1 answer
Sql date time query find
SQL
0 vote251 views1 answer
Automatically update database last seen datetime in sql
SQL