I have implemented custom search to get some values from node.
When I'm using special chars like "/, ?, !", no result is being displayed.
Example value : "24/7" or "site?" or "test!", etc...
$search_text = '24/7'; $query->condition(db_or() ->condition('n.title', '%' . db_like($search_text) . '%', 'LIKE') ->condition('fld.body_value', '%' . db_like($search_text) . '%', 'LIKE'));
I'm running my site in Drupal 7. PHP version is 5.5.9. Using Mysql DB. OS windows.
Note: Query is correct. Its giving proper result for other than special chars.
Edit: $query->arguments(); is returning below image.
I was running LIKE command in phpmyadmin. Please find that screen shot below.
So what is the modification do we need to do at PDO to support this issue?