
18 Nov
2002
18 Nov
'02
7:11 a.m.
I got a question from a user. He has a table with a field (nom) containing first name and last name. When he uses db_search, asking, for example, for marc delisle and with the option "at least one of the words", nothing is found. The generated query contains: WHERE (`nom` LIKE 'marc') OR (`nom` LIKE 'delisle') Of course, if he puts wildcards in the search expression, it works, but it seems not intuitive. It also works with search option 4 (regexp). Shouldn't we add wildcards in db_search for word by word search, so that the generated query had this condition: WHERE (`nom` LIKE '%marc%') OR (`nom` LIKE '%delisle%') Marc