MySQL Forums
Forum List  »  Connector/Node.js

Re: Search in all mysql fields
Posted by: Peter Brawley
Date: September 06, 2019 09:26AM

If you often have to query every column in a table for one search string, there's a database design issue.

Till that's fixed, you could write a function that generates the Where clause ... Where concat(col1,col2,...) Like concat('%',searchstr,'%')

Options: ReplyQuote

Written By
September 05, 2019 11:07PM
Re: Search in all mysql fields
September 06, 2019 09:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.