Compare this search to the same search done using MATCH() AGAINST()
This example shows how to use MySQL to do a very basic search of a database table using the LIKE clause. In MySQL, the LIKE clause allows you to compare any string to the data contained in a field in your database table. If the two match for a particular row, then that row is included in the result set returned by the query.
In this example, we are searching the "title" and "message" fields of the abloomberg_blogposts table. We create a query for searching each field individually, and then use the UNION keyword to combine them into one query.