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

7 votes175 views1 answer
Oracle set sequence value to max(id)
SQL
4 votes171 views1 answer
Add constraint fk
SQL
1 vote185 views1 answer
Postgres concat_ws
SQL
-1 vote193 views1 answer
Mysql select count if contains
SQL
20 votes191 views6 answers
Mysql reset auto increment
SQL
0 vote195 views4 answers
How to get max salary in each department in sql
SQL
0 vote186 views1 answer
Soql user profile
SQL
4 votes174 views1 answer
SQL order random
SQL
7 votes176 views2 answers
Show size database mysql
SQL
2 votes225 views4 answers
Mysql select into new table
SQL