SQL Virgin Needs help

I'm setting up a FAQ page but i would like to add a search section for it, i have never used mssql before yesterday and i'm finding it a bit over whelming,

the faq are written in php... the tables are...

#
# Table structure for table `faqs`
#

CREATE TABLE `faqs` (
`id` int(11) NOT NULL auto_increment,
`category_id` int(11) default NULL,
`question` longtext,
`answer` longtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;


i need to write a query to read all that is in the database and return the information on screen.... with the question and answer from the search word/words the user puts in on a webform.

can anyone help me with what query i use?

Lost & Confused

"i'm somewhere where i dont know where i am!

That table definition is written for Mysql not mssql.

sorry it has been converted now to mssql... it all works etc...

so basically i have 1 database:

help_FAQ

within this i have a 2 table :

`faqcategories`

`faqs`

inside the latter i have
`category_id`
`Questions`
`Answers`

would anyone be able to post an example of how i would pull the information from the database from a key work that has been input by a user doing a search?

any help would be appreciated... i am new to this.....