'% tabelnaam %'

[elpatri]

Is it possible to set up a query like
select * from table where tablename like '%$variable%'

But whit a tablename not a variable ?
I meen this, :
select * from table where tablename like '% tablename %'

?????????

Please help me on this one !

[bastien]

biuld the query out side the function call for simplicity and error checking...

$sql="select * from table where tablename like '%".$ tablename ."%' "

echo the sql back to ensure that what you get is correct...(for development only
🙂

[tomhath]

Sure, both queries you posted are almost valid (I don't think you can have a table in your database named "table" and you will need a column in that table called "tablename").

I get the feeling you are trying to do something else, but that's the answer to the question you posted. 🙂