http://www.codeassembly.com/feed/Mysql Code Assembly - Simplicity is prerequisite for reliability Mysql en-us contact@codeassembly.com contact@codeassembly.com RSS Feed Generator http://www.codeassembly.com/img/logo.png http://www.codeassembly.com 88 31 Simplicity is prerequisite for reliability Some tips on how to get rid of sql injection forever. http://codeassembly.com/Are-you-still-worried-about-sql-injection-?/ 2008-05-17 http://codeassembly.com/Are-you-still-worried-about-sql-injection-?/ Many people ask this question. The answer is very simple, it depends on the context. http://codeassembly.com/When-to-use-join-and-when-to-use-subselects/ 2007-09-16 http://codeassembly.com/When-to-use-join-and-when-to-use-subselects/ Implementing 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. http://codeassembly.com/Implementing-basic-searching-for-your-website/ 2007-09-11 http://codeassembly.com/Implementing-basic-searching-for-your-website/ How 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. http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/ 2007-09-09 http://codeassembly.com/How-to-implement-Mysql-full-text-search-on-a-big-website/