WP search query for custom table
When you need to make search query for custom table you can use it $wpdb -> get_results ( $wpdb -> prepare ( " SELECT * FROM table_name WHERE column_name LIKE %s " , "%" . $wpdb -> esc_like ( $alpcode ) . "%" ) );