There is a field in mysql is json format of data storage, now need to pass an argument from the page to PHP search matching keywords, keyword page I'll json_encode, to match like this field, can't match, for help,,,,

Because of the huge amount of data, read data and then processed and the matching method takes too long, don't want to use this method,

CodePudding user response:

This is very dizzy, you remove the characteristics of the relational database, now want to, which have so good things ah, large amount of data, not index is very slow

CodePudding user response:

Nothing to do, or the building Lord give specific examples and flexible options,

CodePudding user response:

Full-text index, but only 5.6 before MyISAM supports full text indexing, after 5.6 InnoDB also support, but the MySQL own full-text index does not support Chinese,
MySQL indexing tool or find a third party

CodePudding user response:

I do only for Chinese search, save as json data, josn Chinese is generally unicode inside, will be key coding, and then \ u replace _ (underscore) can find out to retrieve,

CodePudding user response:

Is wrong, will be replaced \ _

CodePudding user response:

This problem I have, as with the others said the native writing online also not line, do not know to have a big brand