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

8 votes319 views2 answers
Mysql query dates between two dates
SQL
0 vote389 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote328 views1 answer
Sql get month and year from date
SQL
3 votes360 views2 answers
Mysql update row
SQL
0 vote331 views1 answer
Custom row number
SQL
2 votes312 views3 answers
Replace null in sql
SQL
2 votes319 views1 answer
Oracle index size
SQL
1 vote316 views1 answer
Oracle list constraints
SQL
1 vote357 views1 answer
Postgresql substring last
SQL
10 votes357 views3 answers
Sql select between two dates
SQL