OzPCTrader - Advanced Search

Welcome to my advanced search facility. At first glance it does not look any different from the basic facility but if you follow the examples below you can greatly improve your search results. This facility is based on the boolean full text search in MySQL but not all the features are implemented. This facility is still under development and runs on my private server at home where it accesses a bigger database. Please let me know if you come across any problems or have requests for more features.

Search ozpctrader

Examples

Below you can see some examples of how to take advantage of my advanced search features. The search facility is not case-sensitive and you do not need to worry about capitalisation. Below list is not comprehensive but the listed features definitely work. If you feel adventureous and want to play around a bit, check out MySQL fulltext boolean manual and try it out.

Search term must be found

Lets say you are looking for Jimi Hendrix. If you just enter Jimi hendrix in the form, the search will return any entries that contain either Jimi or Hendrix and therefore include other artists such as Jimi Whiterspoon. To make sure Hendrix is part of ever record returned just add a + in front of Hendrix as shown below.

Jimi +Hendrix

Search term needs to be excluded

If you are looking for pink but you don't want to see any Pink Floyd in the search results you can add a -Floyd to your search as shown below.

Pink -Floyd

Look for an expression

To look for an expression consisting of more than one word just enclose all the words in " (double quotes) as shown below.

"cool down experience"

Combining it all

To look for an expression together with another word just combine the examples above as shown below.

+"cool down experience" +Floyd

Sitemap Home Directory