CREATE TABLE `dynnews_docs` (
  `id` int(255) NOT NULL auto_increment,
  `headline` text NOT NULL,
  `content` longtext NOT NULL,
  `cmd_name` text NOT NULL,
  `lang` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `headline` (`headline`,`content`)
) TYPE=MyISAM;

CREATE TABLE `dynnews_glossar` (
  `id` int(255) NOT NULL auto_increment,
  `name` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `name` (`name`,`description`)
) TYPE=MyISAM;

SELECT id,headline,content,cmd_name FROM dynnews_docs WHERE content LIKE '%$look_for%'

SELECT id,name,description FROM dynnews_glossar WHERE description LIKE '%$look_for%'

INSERT INTO `dynnews_docs` (`id`, `headline`, `content`, `cmd_name`, `lang`) VALUES 
(1, 'Rechtliches', '<h1>Rechtliches</h1>\r\n<hr no[.......]','license','de');
 
//////////////

INSERT INTO `dynnews_docs` (`id`, `headline`, `content`, `cmd_name`, `lang`) VALUES 
(2, 'Nochwas', '<h1>dumdidum...</h1>\r\n<hr no[.......]','anotherone','en');

//////////////

INSERT INTO `dynnews_docs` (`id`, `headline`, `content`, `cmd_name`, `lang`) VALUES 
(3, 'Mal was gaaaanz anderes', '<h1>Not Yet Another News System: dynnews</h1>\r\n<hr no[.......]','blablakey','de');

//////////////

INSERT INTO `dynnews_docs` (`id`, `headline`, `content`, `cmd_name`, `lang`) VALUES 
(4, 'Werbung', '<h1>Ey Leute besucht alle mal dynphp.net^^</h1>\r\n<hr no[.......]','adversiting','de');


////////////// Tabelle 2 (dynnews_glossar)

INSERT INTO `dynnews_glossar` VALUES (8, 'Admin', 'siehe Administrator');
INSERT INTO `dynnews_glossar` VALUES (9, 'Superuser', 'siehe Administrator');
INSERT INTO `dynnews_glossar` VALUES (10, 'Logout', 'siehe Ausloggen');
INSERT INTO `dynnews_glossar` VALUES (11, 'Ausloggen', 'Wenn sie nach dem erfolgreichen Einloggen [...] neu Einloggen.');
INSERT INTO `dynnews_glossar` VALUES (12, 'Einloggen', 'Wenn sie den Administratorbereich betreten wollen loggen sie sich ein.');
INSERT INTO `dynnews_glossar` VALUES (13, 'LogIn', 'siehe Einloggen');

SELECT id, headline, content, cmd_name 
    FROM dynnews_docs 
    WHERE content LIKE '%$look_for%'
UNION
SELECT id, name, description, '' 
    FROM dynnews_glossar 
    WHERE description LIKE '%$look_for%'
    ORDER BY 2 ;