Search Engine Query (Shifted from Programming Newbies)

[@rjun]

Hello everyone!

I've created a database(say tv_shows) with columns(name,path). I want to create a search page for it in php. I am stuck here.
I have already gone through mysql-fulltext search, elasticsearch. But since many shows have same name but only differ at end like S01E12, S01E19,etc. so mysql where condition is something vague for it. Also fulltext search renders numerous results.

Help Me Guys!

[HTH]

Let's learn to google!

"Oh, I want to find a column that contains a certain string..."
*Googles: SQL Query contains string*
*Opens first link*
"Oh I use the LIKE Specifier with % as a wildcard? Cool!"

[@rjun]

i have also used "like" with "%" in it but sir it proves to be futile because:
Let's assume i enter "The big bang theory season 1 episode 12",
and name in database is like the "big bang theory S01E12", so wouldn't  'like' with "%" statement would be futile here?
I also thought about using regex but since there are many other ways of input i am stuck.

Can you provide me some insight how evilzone searches?
Just a request, i would accept a "no".
Thanks

[@rjun]

Sorry for double posting but thanks HTH. I update my name column and added spaces in between and changed "S01E12" to "season 1 episode 12" and then used "like" with wildcard("%") and it is now working.
Sorry for being silly. But i appreciate your concern. Thanks! +1