search in all tables

[TwitterRooms]

hi guys me again this is what i have


$result = mysql_query("SELECT * FROM table WHERE firstname LIKE '%".$searchterm."%'");

which works just great BUT if i want to seach

$result = mysql_query("SELECT * FROM table WHERE lastname LIKE '%".$searchterm."%'");

how so search ALL rows/columns firstname,lastname,username ect

P.S i'm getting it slowly lol

[james438]

It looks like you want to search through multiple columns in one table as opposed to searching through multiple tables, but let me know if I am wrong.

Try this


SELECT * FROM table WHERE (lcase(concat(firstname, lastname, username)) LIKE '%$searchterm%')

[TwitterRooms]

you are correct THANK YOU

[james438]

Glad I could help :)