100 points, urgent and urgent, thinkphp fuzzy query problem, fuzzy query conditions for an array
100 points, urgent and urgent, thinkphp fuzzy query problem, fuzzy query conditions for an array
$map 2[' ornamentations.tags '] =array (' Like ', Array ("% $a 1%", "% $a 2%", "% $a 3%"), ' or ');
The query condition should be and relationship, but write and the error, can not find the results, urgent urgent
------to solve the idea----------------------
Use $map 2[' _string '.
------to solve the idea----------------------
You need to enclose the conditional% with a single quotation mark, or you can return the error when you assemble the SQL.
------to solve the idea----------------------
References:
Quote: References:
Use $map 2[' _string '.
What does this mean? Don't understand
You can find out what's going on in the thinkphp manual by searching for _string, meaning you'll be able to answer the SQL statements you want.
------to solve the idea----------------------
Error output your SQL statement to see SQL stitching errors
------to solve the idea----------------------
Use $map [' _string '] to assign the original ecological where condition statement to this variable ...