PHP Search using WHERE, AND, LIKE, OR Query Functions

How to search multiple fields in a database

Search using WHERE, AND, LIKE, OR Query Functions

  1. Looking for an exact match in field1:
    SELECT * FROM table WHERE field1 = ‘$name’
  2. Looking if the field1 contains the search word anywhere using LIKE and both ‘%%’
    SELECT * FROM table WHERE field1 LIKE ‘%$word%’
  3. Looking if the field1 contains the value that begins with our word using LIKE and the last ‘ %’
    SELECT * FROM table WHERE field1 LIKE ‘$word%’
  4. Looking if the field1 contains the value that ends with our word using LIKE and the first ‘% ‘
    SELECT * FROM table WHERE field1 LIKE ‘%$word’
  5. Looking if our search word appears in both fields using AND
    SELECT * FROM table WHERE field1 LIKE ‘%$word%’ AND field2 LIKE ‘%$word%’
  6. Looking if our search word appears in any of the two fields using OR
    SELECT * FROM table WHERE field1 LIKE ‘%$word%’ OR field2 LIKE ‘%$word%’
  7. Looking if our word is in field1 OR in field2 AND field3 using Parentheses
    SELECT * FROM table WHERE field1 LIKE ‘%$word%’ OR (field2 LIKE ‘%$word%’ AND field2 LIK

You may also like...

12 Responses

  1. how? says:

    what??? explain it carefully

  2. Ohana says:

    SELECT * FROM table WHERE field1 LIKE ‘%$word%’
    this query gives me an error, seems that is not write spelled

  3. anureet says:

    cant understand thecode

  4. This web must have more information,as the given data not clear the concepts

  5. kaleem says:

    SELECT * FROM table WHERE field1 LIKE ‘%$word%’
    this query gives me an error, seems that is not write spelled

  6. james says:

    anureet view this link http://7mliveonline.com/ it will be helpfull for u.
    regards james

  7. waqas umar says:

    i m also going to check it kaleem. thanks in advance.

  8. gery says:

    Ohana here is an excelent link which will be helpfull to u.
    regars gery

  9. gery says:

    waqas here is an excelent link for date diffrence which will be helpfull to u… http://7mliveonline.com/
    regars gery

  10. Rahul says:

    Hi , I want to increase speed of my website search.. please suggest the solutions
    here is the reference http://www.pathankot35.com/

Leave a Reply