5 consecutive words in a sentance to check with mysql database

Question

Please help me , I want to do it with PHP,MySql
Suppose we have a sentence

"A grammatical unit that is syntactically independent and has a subject that is expressed"

I want to retrieve all data which matches with any consecutive five words in the above sentence, that is
"A grammatical unit that is" OR
"grammatical unit that is syntactically" OR
"unit that is syntactically independent" OR etc etc

Can we do with regex match or any easy solution?
Looking forward to you
Thanks

I do not know much about Regex.. But I can give you solution. If you want. — GYaN, Jul 17 '17 at 07:21
http://www.w3resource.com/mysql/string-functions/mysql-position-function.php — Taha Paksu, Jul 17 '17 at 07:23
See something like [this demo at eval.in](https://eval.in/833472) — bobble bubble, Jul 17 '17 at 12:48

Bogdan Mantescu · Answer 1 · 2017-07-17T14:17:28.000

0

You can put that conditions at database level, in mysql you can do this:

 select * from table_name where position('A grammatical unit that is' in field_name) > 0 or position('grammatical unit that is syntactically' in stradacstm) > 0 or position('unit that is syntactically independent' in stradacstm) > 0;

edited Jul 17 '17 at 14:17

answered Jul 17 '17 at 07:33

Bogdan Mantescu

121
6

1

Thank you for this code snippet, which may provide some immediate help. A proper explanation [would greatly improve](//meta.stackexchange.com/q/114762) its educational value by showing *why* this is a good solution to the problem, and would make it more useful to future readers with similar, but not identical, questions. Please [edit] your answer to add explanation, and give an indication of what limitations and assumptions apply. – Toby Speight Jul 17 '17 at 13:56

score 0 · Answer 2 · answered Jul 17 '17 at 07:52

If you want to do it in PHP, you could try something like this:

  $sentence = "A grammatical unit that is syntactically independent and has a subject that is expressed";

$arr = explode(" ", $sentence);

var_dump($arr);
for ($i = 0; $i < (count($arr) - 5); $i++) {

      $newSentence = $arr[$i] + " " + $arr[$i + 1] + " " + $arr[$i + 2] + " " + $arr[$i + 3] + " " + $arr[$i + 4];
  //do database inset here

}

5 consecutive words in a sentance to check with mysql database

2 Answers2