search a entire or only a part of the word.

[stockdiv]

how to change the code, to search ONLY for a entire word?

/members/content_list_vars.php

//Fast query
$com2.=" (b.title like '%".$sch[$i]."%' or b.description like '%".$sch[$i]."%' or b.keywords like '%".$sch[$i]."%') ";

[admin]

The code:

Code: Select all

$com2.=" (b.title rlike '[[:<:]]".$sch[$i]."[[:>:]]' or b.description rlike '[[:<:]]".$sch[$i]."[[:>:]]' or b.keywords rlike '[[:<:]]".$sch[$i]."[[:>:]]') ";

[mj72]

Sorry, I can't find this code line in version 15.


Update:
Found it in content_list_vars.php:

viewtopic.php?f=21&t=1275&p=4284&hilit=search+entire+word#p4284