O'Reilly logo

Sphinx Search by Abbas Ali

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action - normal search in MySQL

  1. Open phpMyAdmin in your browser and create a new database called myblog.
    Time for action - normal search in MySQL
  2. Select the myblog database:
    Time for action - normal search in MySQL
  3. Create a table by executing the following query:
    CREATE TABLE `posts` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `title` VARCHAR( 255 ) NOT NULL ,
    `description` TEXT NOT NULL ,
    `created` DATETIME NOT NULL ,
    `modified` DATETIME NOT NULL
    ) ENGINE = MYISAM;
    

    Note

    Queries can be executed from the SQL page in phpMyAdmin. You can find the link to that page in the top menu.

  4. Populate the table with some records:
    INSERT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required