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 and showing records. Same command is working perfect with old fields like country,browser, etc. But not working with newly added field.
I also created INDEX for this field and I also Optimize table.
Any idea please?