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

1 vote153 views1 answer
Oracle select row max date
SQL
1 vote118 views1 answer
Oracle rolling back
SQL
3 votes137 views1 answer
Sql multi column index performance
SQL
0 vote155 views1 answer
Connect laravel to mysql on mac
SQL
3 votes146 views2 answers
Mysql import gz
SQL
0 vote134 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote168 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote129 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote159 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote137 views1 answer
Plsql check for string in numeric
SQL