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 vote232 views1 answer
T-SQL Never ending DELETE
SQL
1 vote225 views2 answers
Rebuild index sql server
SQL
1 vote223 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
1 vote243 views1 answer
Mysql select and count left join
SQL
0 vote217 views1 answer
Check psql validity function
SQL
7 votes222 views2 answers
Mysql db size
SQL
7 votes227 views6 answers
Reset identity column in sql server
SQL
0 vote239 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
34 votes226 views6 answers
Sql change data type
SQL
7 votes213 views2 answers
Create index mysql
SQL