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.