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 vote305 views1 answer
Import big data to mysql
SQL
3 votes315 views1 answer
Null sql
SQL
7 votes312 views2 answers
Html to react converter
SQL
1 vote308 views1 answer
Alter constraint postgres
SQL
0 vote329 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote293 views1 answer
Mysql command prompt date insert format
SQL
0 vote334 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote307 views1 answer
Sql include rows with 0 values
SQL
1 vote338 views1 answer
Sql server if exists update else insert
SQL
0 vote289 views1 answer
MySql count occurences more than"
SQL