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 -

php - How can I echo out this array? -

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