Is there a way to achieve the user to enter the Arabic numerals query to the corresponding characters of digital information, such as input "chengdu 7", "chengdu 7" information query to the database,
SQL statements, MYSQL

CodePudding user response:

If '17' show 'fashion', it is good to replace directly, if you want to show '17', it is more troublesome

CodePudding user response:

Can, need to create a new table select the original list, select statement for each field in the case when do judgment, the data according to the requirements in the new table, in the normal new table query directly

CodePudding user response:

The best treatment in the application, the parameters of the fuzzy query regular once converted to the corresponding Chinese

CodePudding user response:

Is not directly deal with these Suggestions in SQL, SQL nor expertise in these,

CodePudding user response:

Build an Arab bits Numbers and bits of Chinese characters corresponding to the table, and then use regular expressions to process, should be feasible

CodePudding user response:

Try a regular expression