Using a variable in MySQL 4

[Mr Initial Man]

Statement in its current state:


select Number,
(Select ComicTitle
from standalones
join comicnames on standalones.SoloID = comicnames.SoloID
join comics on comics.comicID = comicnames.comicID
where Number = [Comic_Number]
) AS "ComicName" from comics;


What I need to do is set the variable so that [Comic_Number] will equal Number in this statement.