Specific function-urgent, solution... the table contains a keyword field, which contains 1000 pieces of data and does not contain repeated words.

Source: Internet
Author: User
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 ..

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.