Fetch a post under certain no of words or characters in wordpress? -

Fetch a post under certain no of words or characters in wordpress? -

is possible fetch post content under 140 characters or 25 words ?

if possible how it

here random post code

// random post link function randompostlink(){ $randpostquery = new wp_query(array('post_type'=>array('tip'),'posts_per_page' => 1,'orderby'=>'rand')); while ( $randpostquery->have_posts() ) : $randpostquery->the_post(); echo the_permalink(); endwhile; wp_reset_postdata(); }

character count easy, can add together status and char_length(post_content) < 140 clause.

word count more hard because there no built in mysql function counting words. can find simple solutions don't work in every utilize case finish solutions utilize stored functions. i'll utilize simple solution sake of example.

what need add together filter clause , apply additional conditions there:

add_filter( 'posts_where', 'venki_post_length_limit' ); function venki_post_length_limit($where = '') { remove_filter( 'posts_where', 'venki_post_length_limit' ); $where .= ' , ( char_length(post_content) < 140 or (length(post_content) - length(replace(post_content, ' ', ''))+1) < 25 ) '; homecoming $where; }

notice remove filter function called. don't apply same status every query.

you should aware both of conditions costly compared simple lookup on column value (especially word count). neither can utilize indexes. if have big number of posts may run performance issues if you're running query frequently. improve solution might calculate word , character count when post created/updated , store meta data.

wordpress