If i got a column to put some big texts, how can i make a query with pieces of this texts to select them?

Question

For exemple, i got a column news. How can i make a query with some few words of this text?

Answer 1

You just need to use a LIKE query with wildcards around the text you want to search for, e.g.:

SELECT column1, column2 FROM table WHERE news LIKE '%text to search%';