Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

MySQL help!!

aldacoaldaco Member Posts: 5
Hi, i'm newbie in mysql and querys, and i need a query that shows which element is more often in the table and how many times does it appear.

Thanks

Comments

  • JonathanJonathan Member Posts: 2,914
    : Hi, i'm newbie in mysql and querys, and i need a query that shows which
    : element is more often in the table and how many times does it appear.
    :
    Can you do something like:-

    SELECT fieldname, COUNT(fieldname)
    FROM thetable
    GROUP BY fieldname
    ORDER BY COUNT(fieldname)

    I fear the ORDER BY clause won't work, but do try it and let me know.

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.