ActiveSPLIT.com

How to move Wordpress to a new location in few steps.
- move files, addapt .htaccess, wp-config.php if needed
- backup database
- run the following queries (replace old_url.tld, new_url.tld with actual data)
 
UPDATE wp_options SET option_value = replace(option_value, ‘http://www.old_url.tld’, ‘http://www.new_url.tld’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘http://www.old_url.tld’,'http://www.new_url.tld’);
UPDATE wp_posts SET post_content = replace(post_content, [...]

Getting Top N of a group would be very easy if there just wasn’t that ‘LIMIT & IN/ALL/ANY/SOME subquery’ restriction. But there’s always some way around. Thx to Jon Armstrong from A little Noise for the code hint.

MYSQL table ‘measurements’
| Id | Freq | Level | DateM
## Gets the last 2 measurements for each frequency
SELECT [...]

To disable MySQL FULLTEXT Search stopwords open the mysql config file and below [mysqld] add the following line:
ft_stopword_file = “”
By setting the ft_stopword_file value to an empty string the usual stopwords won’t be ignored any more.
Here is what the manual says about setting a new stopwords file:
To override the default stopword list, set the ft_stopword_file [...]

By default the FULLTEXT minimum characters behaviour is set to 4 characters. To check what value is preset on your server type the following query:
SHOW VARIABLES LIKE ‘ft%’;
That shoud bring up a result similar to this:

Variable_name
Value

ft_boolean_syntax
+ -><()~*:””&|

ft_max_word_len
84

ft_min_word_len
4

ft_query_expansion_limit
20

ft_stopword_file
(built-in)

To change the ftp_min_word_len you have to edit the my.ini configuration file.
Below [mysqld] add this line to decrease the [...]