"LIKE" command of mysql for searching?

[rahulephp]

Hi there,

Could you please help me to find-out the solution?

I need to use "LIKE" command of mysql.

 

Below are title from a Product table. If i search for "Alarm" then it should show me result only for title which has word alarm. (0th and 2nd only)

 

table_name = product

Column_name = title

0 ->Casio G-Shock Velocity Indicator Alarm watch

1 ->Seiko Velatura Tachymeter Chronograph watch

2 ->Citizen promaster Alarm perpetual watch

 

 

Thank you in anticipation

[trq]

SELECT title FROM product WHERE title LIKE '%Alarm%';