mysql remove

[kv79]

hi all

$sql = "ALTER TABLE category1 DROP $Topic_Remove";

I can remove some sting like capital letters , letters , $, but if I put "&⁽&^*%&()&" it can't be deleted 🙁.

Thanks advance .

[Weedpacket]

What are you talking about?

[kv79]

As You can see

$sql = "ALTER TABLE category1 DROP $Topic_Remove";

can remove some string from Database ,but I can't if string contain symbols like &^#$&@$#()*

[laserlight]

You need to quote the column name if it contains special characters or is a reserved word. In MySQL, the default identifier quotes are backticks (the standard identifier quotes are double quotes). As such you should write:

$sql = "ALTER TABLE category1 DROP $Topic_Remove";

If $Topic_Remove itself contains backticks, then you will need to escape them, probably by placing a backslash before those backticks.

That said, when you say "can remove some string from Database", it sounds like you are not aware that you are removing an entire column from the table, not rows for which a particular field matches that string value.

[kv79]

Thank you very much.

[laserlight]

Sure, and remember to mark this thread as resolved (if it is) using the thread tools.