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

1 vote327 views2 answers
Mysql filter by date mount
SQL
0 vote368 views1 answer
Mysql relationships between tables
SQL
0 vote326 views1 answer
Jenkins SQLCMD run
SQL
0 vote349 views1 answer
How to find symmetric pairs in sql
SQL
0 vote331 views1 answer
Change magento database url usimg musql
SQL
1 vote338 views1 answer
Oracle datafile max size 32gb
SQL
0 vote308 views1 answer
Stop psql server windows
SQL
2 votes366 views3 answers
Xampp mysql database not starting
SQL
0 vote310 views1 answer
Json not contains mysql
SQL
4 votes328 views2 answers
Postgre sql create table
SQL