oiksc_404_handler::another_like() – Find potential matches to the query

Description

Find potential matches to the query

See if we can improve on the query to find a potential match WordPress has already run some queries to find a match e.g.

[bw_sql 12 0.001407 wp;WP::main;WP::query_posts;WP_Query::query;WP_Query::get_posts] 

SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_name = 'bbb_oik' 
AND wp_posts.post_type = 'oik-plugins' 
ORDER BY wp_posts.post_date DESC [/bw_sql] 

[bw_sql 13 0.004388 wp_old_slug_redirect] 

SELECT post_id FROM wp_postmeta,  wp_posts WHERE ID = post_id 
AND post_type = 'oik-plugins' AND meta_key = '_wp_old_slug' AND meta_value = 'bbb_oik'[/bw_sql] 

[bw_sql 14 0.001277 redirect_canonical;redirect_guess_404_permalink] 

SELECT ID FROM wp_posts WHERE post_name LIKE 'bbb\\_oik%' 
AND post_type = 'oik-plugins' AND post_status = 'publish'[/bw_sql] 

Perhaps we should choose just one of the words 
or the first character 

We don't want to waste too long as this might be a robot messing about. 

Google would do a lookup of the common mistakes and find it that way 
We could use omniquery or some other search 

Usage

oiksc_404_handler::another_like();

Parameters

Returns

void

Source

File name: oik-shortcodes/classes/class-oiksc-404-handler.php
Lines:

  function another_like() {
    $name = $this->get_name();
    $name = substr( $name, 0, 1 );
    $like = $name;
    return( $like );
  }
 

 View on GitHub