Re: Search Database !

select * from products where prod_name like '%your_word%' or description like '%your_word%'; Replace "*" with whatever you are searching for *or leave it if you want everything), and replace "your_word" with whatever term you are searching for. Chris Septic Flesh wrote:

How can I do the following ? I have the following database: Products ====== cat_id prod_id prod_name description manu_name The user is going to put a word as input, and I wanna search this word in the database. How do I make this QUERY to search for some letters (the given word) in the "prod_name" field or in the "description" field ? Thanks in advance ? -- ~~~~~~~~~~~~~~~~ Sapilas@/dev/pinkeye ~~~~~~~~~~~~~~~~