How to search using the LIKE syntax and % WILDCARD % across multiple tables

baby2j

New Member
How can you use mysql and the like/wildcard syntax across multiple tables, would it be as simple as:\[code\](SELECT * FROM `table1` WHERE `name` LIKE '%tom%') AND (SELECT * FROM `table2` WHERE `name` LIKE '%sam%')\[/code\]Not tested, just thinking about it.
 
Back
Top