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 vote187 views1 answer
No suitable driver found for sqlite
SQL
1 vote203 views1 answer
Ubuntu access database from terminal
SQL
0 vote223 views1 answer
Java sql timestamp now
SQL
1 vote197 views1 answer
Postgresql escape single quote
SQL
0 vote196 views1 answer
Sql count more than 1
SQL
0 vote201 views1 answer
Postgres set default schema
SQL
2 votes195 views2 answers
Oracle no data found error code
SQL
17 votes190 views3 answers
How to change a collumn name in sql
SQL
0 vote203 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes186 views1 answer
Sql get the name of user pc
SQL