MySQL™: The World’s Most Popular Open Source Database 161 4.0: Other Features • SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+apples -bananas' IN BOOLEAN MODE); – Find all records with the word "apples" but not the word "bananas" using a full textindex • SELECT SQL_CALC_FOUND_ROWS ... LIMIT 10 • SELECT FOUND_ROWS(); – Make it possible to display the total number of rows even with a limit. For "10 out of 124 items shown" things • Hash functions: SELECT SHA1("foo") • GRANT .. MAX_QUERIES_PER_HOUR=# MAX_UPDATES_PER_HOUR=# MAX_CONNECTIONS_PER_HOUR=# – Limit a user (Very useful for ISP use) Copyright 2003 MySQL AB