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 vote252 views1 answer
Postgresql alter table sequence
SQL
1 vote214 views1 answer
Sqlite create index
SQL
3 votes210 views1 answer
Mysql set field unique
SQL
0 vote226 views1 answer
Postegresql update to null
SQL
1 vote212 views4 answers
Psql check tables command
SQL
3 votes282 views1 answer
Mysql cli connect with password
SQL
1 vote233 views2 answers
Procedure syntax
SQL
0 vote210 views1 answer
Mod in sql
SQL
0 vote214 views1 answer
Mysql docker image for macbook m1
SQL
1 vote209 views2 answers
End mysql command
SQL