Dec 13th, 2008 by sherlock Hit :: 311
ms_user table
| user_id | username | area_id | |
| 1 | sherlock | c_sherlock@email.com | 1 |
| 2 | poirot | poirot@email.com | 2 |
| 3 | watson | b_watson@email.com | 1 |
| 4 | hasting | hasting@email.com | 2 |
| 5 | mycroft | a_mycroft@email.com | 1 |
SELECT * FROM `ms_user`
ORDER BY `area_id` , `email` DESC , `username`;
Aug 9th, 2008 by sherlock Hit :: 531
The boolean full-text search capability supports the following operators:
1. +
A leading plus sign indicates that this word must be present in every row returned.
2. -
A leading minus sign indicates that this word must not be present in any row returned.
3. (no operator)
By default (when neither + nor - is specified) the word is optional, but the rows that contain it are rated higher. This mimics the behavior of MATCH() … AGAINST() without the IN BOOLEAN MODE modifier.
4. > <
These two operators are used to change a word’s contribution to the relevance value that is assigned to a row. The > operator increases the contribution and the < operator decreases it. See the example below.
5. ( ) Continue Reading »
Aug 9th, 2008 by sherlock Hit :: 448
The MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. The search string is given as the argument to AGAINST(). For every row in the table, MATCH() returns a relevance value, that is, a similarity measure between the search string and the text in that row in the columns named in the MATCH() list.
By default, the search is performed in case-insensitive fashion. In MySQL 4.1 and up, you can make a full-text search by using a binary collation for the indexed columns. For example, a column that has a character set of latin1 can be assigned a collation of latin1_bin to make it case sensitive for full-text searches. Continue Reading »
Jul 31st, 2008 by sherlock Hit :: 531
Jul 25th, 2008 by sherlock Hit :: 387
PageRank is considers the importance of each page that casts a vote, as votes from some pages are considered to have greater value, thus giving the linked page greater value. We have always taken a pragmatic approach to help improve search quality and create useful products, and our technology uses the collective intelligence of the web to determine a page’s importance.
from: google.com
Source :: http://www.smiling-dolphin.com
It may look daunting to nonmathematicians, but the PageRank algorithm is in fact elegantly
simple and is calculated as follows: