Need A MYSQL Command

Discussion in 'MySQL' started by aaron_nimocks, Feb 20, 2007.

0
  1. #1
    I need to search through a database and find data that is over a certain amount of characters.

    So in my 'navy_quiz' table in my 'questions' row I want to do a query to find all rows that exceed 125 characters. How can I do this?

    I always green for help! :)
     
    aaron_nimocks, Feb 20, 2007 IP
  2. disgust

    disgust Guest

    Messages:
    2,417
    Likes Received:
    133
    Best Answers:
    0
    Trophy Points:
    0
    #2
    use char_length() :)
     
    disgust, Feb 20, 2007 IP
  3. aaron_nimocks

    aaron_nimocks Im kind of a big deal Staff

    Messages:
    5,563
    Likes Received:
    627
    Best Answers:
    0
    Trophy Points:
    420
    #3
    Im a mysql dummy can you give me the full command?

    select * from navy_quiz blah blah
     
    aaron_nimocks, Feb 20, 2007 IP
  4. rajnikant

    rajnikant Peon

    Messages:
    18
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    This would be a complete query for you...

    SELECT *
    FROM `navy_quiz`
    WHERE LENGTH( questions ) > 125
     
    rajnikant, Feb 20, 2007 IP