mysql query problems: Need help!

[Anon]

Ergh. I'm having some difficulties. I want to do a query that does something like this:

(select * from table where columna=columnb and columnc LIKE $variable)

Except it isn't working! What am I doing wrong? Or is this just not even possible?

[brandonschnell]

select * from table where columna=columnb and columnc LIKE '$variable'

other than that we'd need to know the error message

[Anon]

your $variable would be like "%string%",I have test that if the $variable="string",the result will not be your wanted,but $variable="%string%' is right!🙂