'MySql REGEXP multiple words search
search from databse with REGEXP
I have a phrase of a few words that I want to search in the database but it does not output, but with the same command if it is a word, it finds values and does not find for two words or more
keyword = 'یوسف نبی'
pattern: [يىئۦ][ً-ٰٓـ]*[وؤۥ][ً-ٰٓـ]*س[ً-ٰٓـ]*ف[ً-ٰٓـ]*+[ً-ٰٓـ]*ن[ً-ٰٓـ]*ب[ً-ٰٓـ]*[يىئۦ][ً-ٰٓـ]*
SELECT * FROM `table` WHERE `column` REGEXP '{$_POST['pattern']}'
no result
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|