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
Tagged : / / / / / / /

10 thoughts on “PHP Search using WHERE, AND, LIKE, OR Query Functions

Leave a Reply

Your email address will not be published. Required fields are marked *