select id
from Table
where title like '%Dir Clinical - Acting Clinical Director%'
OR title like '%Dir Clinical - Assistant Director of Nursing%'
mysql like does not give any results for the above query,even though there are records in the table, may be due to hyphen in between. But when i try to remove the text before hyphen and query with the remaining text, getting wrong results
Could any one of you explain this issue, where getting zero results with there is a hyphen in between the text while applying like
In MySQL you have two wilcards, % to match multiple characters and _ to match exactly one character. So assuming the hyphen really is the problem, you can try:
'%Dir Clinical _ Acting Clinical Director%'
That will allow any character to be in the hyphen spot, and solve the problem of unicode hyphens vs regular or similar issues.