GROUP_CONCAT(cat.name ORDER BY cat.term

GROUP_CONCAT(cat.name ORDER BY cat.term_id SEPARATOR

select p.id as pid,p.post_title,p.post_content,GROUP_CONCAT(cat.name ORDER BY cat.term_id SEPARATOR
',') as catname,cat.slug as catslug from wp_posts as p left join wp_term_relationships as r on p.id =
r.object_id left join wp_term_taxonomy as t on r.term_taxonomy_id = t.term_taxonomy_id left join
wp_terms as cat on t.term_id = cat.term_id where id in (select id from wp_posts) GROUP BY pid ORDER BY
pid desc limit 0,10

Comments

SQL_CALC_FOUND_ROWS command fetch row count without limit

select SQL_CALC_FOUND_ROWS from <tablename> where flag = 1 limit 10 and then select found_rows();

Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT); INSERT INTO numbers VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), select id, substring_index( substring_index(email_recipients, ',', n), ',', -1 ) as email from dashboards join numbers on char_length(email_recipients) - char_length(replace(email_recipients, ',', '')) >= n - 1 Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/

Custom Sorting Array List in PHP

<?php $order = array("Z","Srilanka","34", "Canada", "India", "USA"); $array = array( array('id' => 7867867, 'title' => 'USA'), array('id' => 3452342, 'title' => 'India'), array('id' => 1231233, 'title' => 'Srilanka'), array('id' => 5867867, 'title' => 'Z'), ); usort($array, function ($a, $b) use ($order) { $pos_a = array_search($a['title'], $order); $pos_b = array_search($b['title'], $order); return $pos_a - $pos_b; }); print_r($array); ?>

Shanky Phoenix

Search This Blog