How do I search my db?

[ballhogjoni]

I have setup a form for the user to search my db for a term but, I don't know how to search all table in my db for the keyword. My code only works for one table:

 

SELECT * FROM `Articles` 
WHERE (`title` REGEXP CONVERT(_utf8 'credit cards' USING latin1) COLLATE latin1_swedish_ci 
OR `tinymcedata` REGEXP CONVERT(_utf8 'credit cards' USING latin1) COLLATE latin1_swedish_ci 
OR `author_id` REGEXP 'credit cards' OR `topic_id` REGEXP 'credit cards' 
OR `display_on_home_page` REGEXP 'credit cards' OR `publish_date` REGEXP 'credit cards' 
OR `meta_title_addition` REGEXP CONVERT(_utf8 'credit cards' USING latin1) COLLATE latin1_swedish_ci 
OR `meta_description_addition` REGEXP CONVERT(_utf8 'credit cards' USING latin1) COLLATE latin1_swedish_ci 
OR `meta_keywords_addition` REGEXP CONVERT(_utf8 'credit cards' USING latin1) COLLATE latin1_swedish_ci)

 

Can anyone show me how to search the entire db for the keyword?

[sageauk]

try this maybe it might help you

http://dev.mysql.com/doc/refman/5.0/en/union.html

[ballhogjoni]

I setup a union select but now I get an error that says: The used SELECT statements have a different number of columns

 

Each table has different amount of colums, how do I get around this error?