CREATE TABLE table_46547 ("Name" TEXT, "Date" TEXT, "Defending forces" TEXT, "Brigade" TEXT, "Population" TEXT)

What is the brigade when Al-Hamra ('arab al-hamra) shows for name?
SELECT "Brigade" FROM table_46547 WHERE "Name" = 'al-hamra (''arab al-hamra)'
SELECT "Brigade" FROM "table_46547" WHERE "Name" = 'al-hamra (\'arab al-hamra)'