Double-page supporter
- Joined
- Mar 4, 2018
- Messages
- 602
How about creating a separate database table for manga authors? As far as I can tell your current implementation has them just as a string column in the manga table, as you can browse their works only by doing a search. So this leads to situations where you want to find all manga by 'ONE' but instead get a search result for something like "SELECT * FROM manga WHERE author LIKE '%ONE%'" and end up with mostly incorrect results.
Of course this would lead to extra work as you'd need to merge data where author has been typoed or exists under multiple pseudonyms.
Of course this would lead to extra work as you'd need to merge data where author has been typoed or exists under multiple pseudonyms.