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 vote357 views2 answers
Mysql create table if not exists
SQL
0 vote347 views1 answer
Join in update query in mysql
SQL
23 votes359 views3 answers
Sql where contains part of string
SQL
0 vote354 views1 answer
Get enginge db mysql
SQL
1 vote342 views3 answers
Postgresql crete view
SQL
7 votes343 views6 answers
Group_concat mysql
SQL
1 vote339 views1 answer
Mysql random limit 1
SQL
4 votes348 views1 answer
SQL find text in SP
SQL
2 votes347 views1 answer
Mysql Incorrect column specifier for column
SQL
18 votes325 views2 answers
Sql comments
SQL