Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Id, Name FROM my_table WHERE Name LIKE '%prashant%' LIMIT 0, 10;
- SELECT SQL_CALC_FOUND_ROWS
- Id, Name
- FROM my_table
- WHERE
- Name LIKE '%prashant%'
- LIMIT 0, 10;
- # Find total rows
- SELECT FOUND_ROWS();
Add Comment
Please, Sign In to add comment