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 vote257 views1 answer
Sql convert datetime to year
SQL
4 votes268 views1 answer
Mysql query first character
SQL
9 votes274 views1 answer
Alter table column change data type to text mysql
SQL
0 vote287 views4 answers
Restart MySQL
SQL
0 vote255 views1 answer
Sql describe
SQL
1 vote277 views1 answer
Mysql datetime with timezone offset
SQL
0 vote208 views1 answer
Testing sql queries
SQL
3 votes254 views4 answers
Mysql create table from select statement
SQL
7 votes252 views2 answers
Get database size mysql
SQL
1 vote257 views1 answer
Select from one table where not on the other
SQL