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 vote131 views1 answer
Suse start MySQL
SQL
1 vote130 views1 answer
Scaffold mysql database
SQL
0 vote131 views1 answer
Oracle last character of string
SQL
0 vote165 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote149 views1 answer
Interview experience as a call?
SQL
23 votes129 views6 answers
How to create table in sql
SQL
6 votes129 views1 answer
Wordpress change user password sql
SQL
3 votes142 views3 answers
Stop mysql service ubuntu
SQL
0 vote142 views1 answer
Cast float mysql
SQL
0 vote200 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL