Order_isses, MySQL

Language: Layout:

#select version() as 'mysql version'
drop table if exists tablex;

create table tablex(
    category varchar(255),
    brandname varchar(255),
    dosage varchar(255),
    image varchar(255)
);
insert into tablex(category,brandname,dosage,image) values
('5-Lipoxygenase Inhibitor','Zyflo CR Extended-release tablet','600 mg','Zyflo CR Extended-release tablet 600 mg.jpg'),
('5-Lipoxygenase Inhibitor','Zyflo CR Extended-release tablet','600 mg','Zyflo CR Extended-release tablet 600 mg.jpg'),
('', ' SEE NOTES BELOW','',''),
('Inhaled corticosteroids', 'Alvesco HFA','80mcg','Alvesco HFA.jpg');

#select * from tablex;
#SELECT * FROM tablex WHERE CONCAT(brandname, ' ', dosage) IN ('Zyflo CR Extended-release tablet 600 mg',' SEE NOTES BELOW','Zyflo CR Extended-release tablet 600 mg') ORDER BY FIELD(CONCAT(brandname, ' ', dosage),'Zyflo CR Extended-release tablet 600 mg',' SEE NOTES BELOW','Zyflo CR Extended-release tablet 600 mg');
SELECT t.* FROM (SELECT 1 as seq, 'Zyflo CR Extended-release tablet 600 mg' as item UNION ALL SELECT 2, ' SEE NOTES BELOW ' UNION ALL SELECT 3, 'Zyflo CR Extended-release tablet 600 mg' )AS inList INNER JOIN tablex AS t ON inList.item = CONCAT(t.brandname, ' ', t.dosage) ORDER BY FIELD(CONCAT(brandname, ' ', dosage),'Zyflo CR Extended-release tablet 600 mg',' SEE NOTES BELOW ','Zyflo CR Extended-release tablet 600 mg');


absolute service time: 0,36 sec