When to use join and when to use subselects
2007-09-16Many people ask this question. The answer is very simple, it depends on the context.
Read moreMany people ask this question. The answer is very simple, it depends on the context.
Read moreImplementing basic searching for your website using mysql's full text search, and also some tips on how to refine your searches using fulltext boolean search.
Read moreHow to implement Mysql FULL TEXT search on a big website, with million of rows and multiple tables. In case you didn't know, you can't use FULL TEXT when joining two tables, and in most of the cases you have multipe tables to search(normalization) . Here is how you can implement your search, I will show this on a real world example.
Read more