1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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