Counting a multiple element in mysql

SELECT COUNT(IF(row_name='Type',1, NULL)) 'Type', COUNT(IF(row_name='Price',15, NULL)) 'Price' FROM table_name;

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.