Hundreds records in table but sql command not working

Discussion in 'MySQL' started by mi6hq, Oct 19, 2018.

0
  1. #1
    I am working in cPanel > phpmyadmin

    I just added one new column name "host_name" in table and there are hundreds records with value "mojotype.net" in host_name field. I am using following command to filter records:

    SELECT * FROM `visitors` where host_name='mojotype.net'

    Note: There are 60,000+ records in table.

    I am NOT new to phpmyadmin and I work in routine but can't figure out why sql command is not working for this field.

    I also created INDEX for this field and I also Optimize table.

    Any idea please?

    MI6
     
    mi6hq, Oct 19, 2018 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    Do:
    SELECT * FROM visitors WHERE `host_name`='mojotype.net'
    PHP:
     
    PoPSiCLe, Oct 19, 2018 IP