Select something starting from "a"?

What i want is to select everything from a database that has this letter ";" infront of any name. Say:

;name
;nickname
;so on...

like:

SELECT * FROM table WHERE name = ";" will seek only for something that has only ";"

and I want to select only letter who start from ";"

use LIKE instead of the equal sign, and a wildcard:

SELECT * FROM table WHERE name LIKE ';%'

thank you... but what if we want to search for a single quote?

we have to type a backslash first?

select * from table where column like '\'%' ?????????????

should work, I think, or you may use the singlequote itself for escaping

LIKE '''%'