0

I have a table with one field as name.The values in this fields are

  • kiran-(ki-ran).txt, arun-(ar-un-ki-ran).txt, aby-(ki-ran-aby).txt

How i can search the values excatly matching ki-ran(inside bracket) from this values so i can get only kiran-(ki-ran).txt i have used LIKE ('%ki-ran%') But it is showing all the values.Thanks in advance

Improve this question

1 Answer 1

Reset to default
1

Your LIKE clause should look like LIKE '%(ki-ran)%'.

Improve this answer
0

Not the answer you're looking for? Browse other questions tagged or ask your own question.