search - Return all INSTR or LOCATE instances in MySQL -


i have text column containing large amount of text (for arguments sake let's assume it's novel). need use mysql locate words or phrases within novel. using instr or locate find word or phrase , return position (which ideal), returns first instance, need return instances. there way of doing this?


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

javascript - IE11 incompatibility with jQuery's 'readonly'? -

php - How can I echo out this array? -