How to specify index in the DB query for the string in a column

[Pooja11]

In my database I have a column which contain location of a file. The column contains entries like -
 

scripts/testSuite/sdnSTC/Flare/Backup_Restore/Sprint16_tests/BackupHugeDatabase.tcl

scripts/testSuite/sdnSTC/Flare/Backup_Restore/Standalone_backup/Backup_Restore_BackupRestoreApplications.tcl

scripts/testSuite/networkSecurity/802dot1x/802dot1xConfiguration/802dot1xBasicUserMode.tcl

scripts/testSuite/hostAgentFeatures/debugLogging/debugLoggingFeatureTesting/DebugLoggingIPv6Forwarding.tcl

 

I want to query this database and check for the values like networkSecurity, hostAgentFeatures etc at the specified index 2.

I tried using REGEXP and LIKE but it does not always returns the correct output. Also my DB doesn't support FULLTEXT indexes

Is there a way to specify index in MySQL ?

Please guide.

[fenway]

You can do magic with SUBSTRING_INDEX and POSITION, but I'm not sure you want to.