Help for this page

Select Code to Download

Select or download this

SELECT COUNT(*) FROM table WHERE numeric_column < 
  (SELECT numeric_column FROM table WHERE your_criteria)

Select or download this

mysql> explain select count(*) FROM faar_homes WHERE price < 80000 \G
*************************** 1. row ***************************
...
          ref: NULL
         rows: 25
        Extra: where used; Using index