Search box type in the title or the author the SQL query book how to write

CodePudding user response:

Select * from table name where the title field like '% % input values or author field like' % % input values'

CodePudding user response:

right upstairs, but also pay attention to the % x % of a full table scan performance problems

CodePudding user response:

thank you very much

CodePudding user response:

Using SQL like '% % values'

CodePudding user response:

Thank you for the