How to search in MySQL using PHP

Discussion in 'PHP' started by FokeBox, Apr 13, 2013.

0
  1. #1
    Hello all, I have made some mysql search!
    So for example I have this words in mytable: "Book", "Book for Children", "Books for Adults"
    When I search "Book" so I have all this sentances in results ("Book", "Book for Children", "Books for Adults") ... so if I search Book the result should be "Book"
    How to orginize it?
    I use this code:
    $raw_results = mysql_query("SELECT * FROM table WHERE (`row` LIKE '%".$query."%')") or die(mysql_error());
     
    FokeBox, Apr 13, 2013 IP
  2. essadik34

    essadik34 Active Member

    Messages:
    67
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #2
    $raw_results = mysql_query("SELECT * FROM table WHERE (`row` = '".$query."')") or die(mysql_error());
     
    essadik34, Apr 13, 2013 IP
  3. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    737
    Likes Received:
    52
    Best Answers:
    33
    Trophy Points:
    150
    #3
    I would take it another step and normalize capitalization:

    
$raw_results = mysql_query("SELECT * FROM table WHERE LOWER(row) = '".strtolower($query)."'") or die(mysql_error());
    Code (markup):
     
    ThePHPMaster, Apr 13, 2013 IP