Lines overlapping each other for normalization...

[Romoblogger]

As seen above, I want to create a separate table to eliminate duplicate rows. Instead of writing the same sections repeatedly, I will use the IDs of the sections. So far, no problem. However, as visualized, the difference between Mechanical Engineering and Mechanical Engineering (English) is not in the sections, only the language of the section is different. I should consider this as a separate column in the sections table. There is no issue logically, but how can I handle cases like Mechanical Engineering, Mechanical Engineering (O), and Mechanical Engineering (English)? I haven't been able to generate a suitable query. Is there anyone who can help with this? (EDIT: The issue was resolved with the query select IF(LOCATE('(', sectionName),SUBSTRING_INDEX(`sectionName`, '(', -1), null) from sections.)