What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-27 22:42:02
mysql offset from bottom
SELECT id FROM table ORDER BY id DESC LIMIT 5 If you like to select entries 10,9,[8,7,6,5,4],.. try (3 start index, 5 row count) SELECT id FROM table ORDER BY id DESC LIMIT 3,5 Or 1,2,3,[4,5,6,7,8],9,10 SELECT id FROM table ORDER BY id ASC LIMIT 4,5 Add solution -
SQL 2021-09-16 12:02:04
mysql select last 10 rows
SELECT fields FROM table ORDER BY id DESC LIMIT 1; Add solution -
-
PHP 2021-08-31 12:56:02
pdo search query
$search_keyword = ''; if(!empty($_POST['search']['keyword'])) { $search_keyword = $_POST['search']['keyword']; } $sql = 'SELECT * FROM posts WHERE post_title LIKE :keyword OR description LIKE :keyword OR post_at LIKE :keyword ORDER BY id DESC '; ... ... ... Add solution
Best helpers
Ranking is empty