dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Search database with two words

  1. #1
    Join Date
    May 2012
    Posts
    1

    Search database with two words

    Hi there,
    Totally new to mysql.
    I hope this is easy.
    Just want to search for results with

    Fire AND poi in the field.

    So this would exclude results with fire alone, or poi alone.

    SELECT * FROM isc_products WHERE prodname like '%$search%' LIMIT 100

    I try the AND which brings back results with either.

    Hope this makes sense and is an easy thing to achieve.
    Thanks heaps
    Jason

  2. #2
    Join Date
    Apr 2012
    Posts
    22
    Read more about the Boolean fulltext - http://dev.mysql.com/doc/refman/5.5/...t-boolean.html

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles