"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

[Atli]

Hey.

See 11.4.1. String Comparison Functions and 3.3.4.7. Pattern Matching in the manual.

In short, the % char is a wild-car char that can be used with the LIKE operator. You can add it at any point in the search phrase, so to search for any occurrence of a keyword in the given column, you would surround the keyword with the wild-card.

[rahulephp]

Hey thanks
I got the solution.

Below command gives all results having keywords Alarm or watch

SELECT * FROM product where title LIKE '%Alarm%' or '%watch%'