For instance, if my table was set up like this:
Database: test_db
Table: test_table
Columns: ID int(4), dataName varchar(255), dataContents text
How would I query the database so that it returns all rows in which "dataContents" contains a phrase such as "ipsum epsum". The phrase could be anywhere within the text field. For example:
"Indige huetoro ipsum epsum floro dolore"
Can I use LIKE? Or is there even a way to do this with mysql commands? Any suggestions would be greatly appreciated. Thank you