"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
interactivetools.com