"fieldname_prefix" search type

3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 22, 2018   (RSS)

By gversion - May 21, 2018

Hello,

Am I right to think that the "fieldname_prefix" search type is just carrying out a WHERE clause? If so, can someone please tell me what the SQL where operator is? I am referencing this link: https://www.w3schools.com/sql/sql_where.asp

Thank you,

Greg

By leo - May 22, 2018

Hi Greg,

Not quite but in the end, the search query will become a where statement to the SQL query. You can replicate a prefix search query with 'field LIKE "keyword%"'.

Thanks,

Leo - PHP Programmer (in training)
interactivetools.com