Search Query
Posted: Mon Aug 11, 2003 1:03 pm
Hey
Is it possible to search from 2 tables in mysql?
e.g. i have an advert table and an announement table.
I want to try and make a search form , that will query the database of keywords and search the 2 tables
is that possible?
i know that one table would be
select * from advert where description like "%blah%";
but not sure if you can do 2 tables. They do not have a relationship.
Is it possible to search from 2 tables in mysql?
e.g. i have an advert table and an announement table.
I want to try and make a search form , that will query the database of keywords and search the 2 tables
is that possible?
i know that one table would be
select * from advert where description like "%blah%";
but not sure if you can do 2 tables. They do not have a relationship.