How to use wildcard in mysql query?

Question

Hi I want to find out one way to do string search in MySQL query (with wildcard)

In a db table known as "table1", I have the following records (serial, text1)

serial	text1
1	Building in New York
2	Building in Paris
3	New York tall Building
4	Small New York Building
5	Building in Singapore

question from:https://stackoverflow.com/questions/65878524/how-to-use-wildcard-in-mysql-query

Answer 1

Waitting for answers