saisir la première ligne dans une requête mysql seulement

90

SELECT * FROM tbl_foo WHERE name = 'sarmen' LIMIT 1 

81

SELECT t.*,        @rownum := @rownum +1 AS rank   FROM TBL_FOO t   JOIN (SELECT @rownum := 0) r  WHERE t.name = 'sarmen' 

77

SELECT COUNT(*) FROM tbl_foo WHERE name = 'sarmen' 

SELECT * FROM tbl_foo WHERE name = 'sarmen' LIMIT (n - 1), 1 

SELECT * FROM tbl_foo WHERE name = 'sarmen' LIMIT 2, 1