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 vote132 views1 answer
Flask sqlalchemy update row
SQL
0 vote134 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote145 views1 answer
Sql column contains special character
SQL
0 vote149 views1 answer
Java check if something is in mysql table
SQL
-1 vote143 views1 answer
Insert results of a stored procedure into a temporary table
SQL
11 votes142 views2 answers
MySQL DISTINCT
SQL
1 vote134 views3 answers
Connect to mysql c# connection string C#
SQL
1 vote140 views1 answer
Mysql copy table1 to table2
SQL
0 vote169 views1 answer
Consulta alias con inner join
SQL
0 vote136 views1 answer
Fast sql column count
SQL