CREATE TABLE `ls_answers` (
`aid` int(20) NOT NULL auto_increment,
`qid` int(20) NOT NULL,
`uid` int(20) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`date` datetime NOT NULL,
`rating` float NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- Daten für Tabelle `ls_answers`
-- 

INSERT INTO `ls_answers` (`aid`, `qid`, `uid`, `subject`, `message`, `date`, `rating`) VALUES (1, 1, 38, 'subject1', 'Your message', '0000-00-00 00:00:00', 0);

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `ls_questions`
-- 

CREATE TABLE `ls_questions` (
`qid` int(20) NOT NULL auto_increment,
`uid` int(20) NOT NULL,
`category` int(20) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`date` datetime NOT NULL,
`rating` float NOT NULL,
PRIMARY KEY (`qid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `ls_questions`
--

INSERT INTO `ls_questions` (`qid`, `uid`, `category`, `subject`, `message`, `date`, `rating`) VALUES (1, 38, 0, 'fff', 'Your message. Max. 1000 Chars', '2007-11-21 17:34:00', 0),
(2, 38, 0, 'my topic', 'your message. my question', '2007-11-21 20:36:20', 0);

select *
from ls_questions
left join ls_answers on(ls_questions.qid=ls_answers.qid)
where (ls_questions.message like '%your%' or ls_answers.message like '%your%')