How to find records in a table that match a value

xulei2jj

For example, if you query all the videos that an actor has performed, if the field of the actor has Keanu Reeves, Keanu Levis, and Keanu Reeves, how should the sql statement to query the record of his movie be written?
select * from movieinfo where actor ...? ?

lj0917

select * from movieinfo where actor like '% 李维斯%'


select * from movieinfo where charindex ('Levis', actor)> 0

fanfan1980

--try

select * from movieinfo where charindex ('Keanu-Levis', actor)> 0

select * from movieinfo where actor like '% Keanu-Levis%'