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 vote104 views1 answer
Mariadb set vertical output format
SQL
0 vote127 views1 answer
Sql alternative to max statement
SQL
2 votes147 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote129 views1 answer
Kill slow queries mysql
SQL
0 vote125 views1 answer
Change schema of all tables postgres
SQL
1 vote158 views2 answers
Install sql server management studio ubuntu
SQL
0 vote124 views1 answer
Set default value now() date
SQL
0 vote134 views1 answer
Change magento database url usimg musql
SQL
0 vote163 views1 answer
Psql create usr
SQL
0 vote142 views1 answer
Mysql get only the field names in a table
SQL