You have a Cloud SQL for MySQL instance with a table of product information including a column of product descriptions. Your application development team is building a customer facing chatbot and would like to find the product that most closely matches a freeform text description provided by the customer. How should you enable this functionality?

A. Create a stored procedure that uses a regular expression to match the customer’s search text to values in the product description column. B. Create and populate a column of product description embeddings on the product table and perform an approximate nearest neighbor search using the customer’s search text. C. Use the LIKE operator to match the customer’s search text to the product description and return similar rows. D. Create a SQL script that compares the product description and the customer’s search text by using the SOUNDEX function.