1. there is a table in the mysql database, and there are 1000 pieces of data. The table contains a keyword field. each keyword is an array composed of multiple words. Separated by "|", ", or spaces. Now we need to obtain words that are not repeated in all keywords. Example: Keyword: 01. liaoning | Shanghai | China | International, Asia, Europe 02. result: Liaoning Shanghai China International Asia Europe Tianjin Shandong data: database name: qwer table name: qaz data entries: 1000 Keywords field: gjczd requirements: write out a specific process (including links to databases, SQL statements, and specific functions, and introduce their ideas... specific functions mysql keywords do not repeat keyword fields SQL statements
1. there is a table in the mysql database, and there are 1000 pieces of data. The table contains a keyword field. each keyword is an array composed of multiple words. Separated by "|", ", or spaces. Now we need to obtain words that are not repeated in all keywords.
Example: Key words: 01. Liaoning | Shanghai | China | International, Asia, Europe
02. Liaoning, China, Tianjin, Shandong
Result: Liaoning, Shanghai, China, international, Asia, Europe, Tianjin, Shandong
Data: database name: qwer
Table name: qaz
Number of data entries: 1000
Keywords: gjczd
Requirement: write out a specific process (including links to databases, SQL statements, and specific functions, and introduce their ideas)
The number of lines of code cannot exceed 30.
Urgent... solving ..