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

6 votes248 views2 answers
How to get last element sql
SQL
0 vote190 views1 answer
Sub blocks in sql
SQL
0 vote186 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote293 views1 answer
SQL check if record exist
SQL
0 vote243 views1 answer
Combine 2 columns search query mysql
SQL
0 vote229 views1 answer
Check constraint is violated
SQL
2 votes200 views1 answer
Mysql sysdate - 1 day
SQL
1 vote215 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote217 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote194 views1 answer
Get yesterday date ISO in psql
SQL