Re: Search in all mysql fields
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,'%')
Subject
Written By
Posted
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.