Assume, I have table which consists of 5 values, say
I want to query the database table to get the values starts from 'C:/Testing/' and '/' as a escape character.
ie, I want to get only two things,
Both starts with 'C:/Testing/' and the next escape character is '/' .
Similarly, if query the database which starts with 'C:/' it should give the following details:
I have tried LIKE query and REGEXP queries. But seems no luck.
Could any one update me, is there any way to do it.
Thanks in Advance,