how can the data shown in the following figure be stored in the mysql database?
45:
how do I store the classification and group information of trademarks? And the receptionist can conduct multiple queries (multi-conditional search)?
what I"ve come up with so far is that the datasheet has two fields, one field, cate, to store trademark classifications, and the other field, group, to store groups.
for example: there are three categories and groups of trademark registration whose trademark name is "Hello":
category 1: 0101, 0102, 0103, 0104, 0105, 0106
2: 0203, 0204, 0205, 0206, 0207
3: 0401,0402,0403,0404,0405,0406,0407
then, when storing the information of the trademark:
the value of the cate field is stored as follows: 1the value of the cate field is stored as follows: 1the value of the group field is stored as follows: 0101J 0102je 0103 group: 0104je 0105je 0106je 0203je 0203je 0205je 0205je 0407
if the trademark data is stored in this way, how does the receptionist make multiple queries? How are SQL filtering statements organized?
if the user selects categories 1 and 2, and selects 0101, 0102, 0104 under category 1 and 0201, 0202, 0206 under category 2, confirm to submit the search. Background SQL filter statement:
select Trademark name
from Trademark Information Table
where
FIND_IN_SET and
FIND_IN_SET ("0101jewelry penny) and
FIND_IN_SET (" 0202jewelry) and
FIND_IN_SET ("0206" Group)
order by cate asc
I would like to ask if this way of thinking is too clumsy, here, ask the gods! Thank you.