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 - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -