php - How to write a query that selects 9 rows randomly from database?
652
SELECT * FROM tbl_specialisation
WHERE LENGTH(spec_specialise) < 20 ORDER BY spec_specialise LIMIT 9
add to this query
People are also looking for solutions to the problem: php - show custom fields data in next and previous link in wordpress
Didn't find the answer?
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Write quick answer
Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.
Similar questions
Find the answer in similar questions on our website.
- 315 php - smtp email with pear library is not working gives error
- 396 php - Laravel 5.6.15 does not want to accept my post requests
- 73 php - Timber/WooCommerce 3.3.x issue?
- 908 php - Not Redirecting header() . Not echoed anything
- 776 php - laravel execute code after return
- 76 can any one help to me to get variable from jquery and use in php
- 320 PHP MySQL if row exists not doing anything
- 84 php - String of file_get_html can't be edited?
- 897 php - Modify files in /vendor directory and commit changes to composer.lock?
- 803 php - After woocommerce/wordpress registration
- 267 php - Zend Framework 2: Extend ZfcUser with own fields
- 903 php - Symfony Doctrine One to Many does not insert foreign key
- 441 php - Apache2 ModSecurity2 does not work (Ubuntu 14.04)
- 84 php - Merge rows between two arrays of objects based on column value
- 319 php - captcha code interfering with form handler
Answer
Solution:
"SELECT * FROM
tbl_specialisationWHERE LENGTH(spec_specialise) < 20 ORDER BY RAND() LIMIT 9 ";Answer
Solution:
USE
ORDER BY RAND()Answer
Solution:
Your question is not clear because you are asking 9 random fields but in SQL query you are trying to get 9 records. If you want to get 9 records from table then use following.