Reply to thread

Message: <blockquote data-quote="Ayeshlive" data-source="post: 18594567" data-attributes="member: 363439">Mekai machan. Programming kiyanne Q&A newei. Umba PHP karanawanam "Modernizing Legacy Apps PHP" kiyana book eka kiyawapan. Client requirements walata shitty code liyanawa kiyana eka excuse ekak newei.Umbe second question ekata answer eka mekai. MySQL wala string functions walin one widihata string eka modify karagaththama e select items group by query walatath ganna puluwan. Example:<a href="http://sqlfiddle.com/#!9/5d759/3" target="_blank">http://sqlfiddle.com/#!9/5d759/3</a>[CODE]SELECT SUBSTRING_INDEX(name, '-', 1) AS item_code, COUNT(name) as cnt FROM items GROUP BY item_code;[/CODE]Methana SUBSTRING_INDEX eken name kiyana field eke thiyena first string eka gannawa dash sign ekata kalin thiyena. Eka ayeth GROUP BY clause ekakata use karannath puluwan. Meke performance nam charter. </blockquote>

Top Bottom