I have a field in a database which has variations of the following code:
VI:NA|OT:NA|
I have tried everything I can in sql, but nothing allows me to search for strings like
VI*
I need to search strings like the one above, but I cannot do an =, because all I am looking for is the two letter VI information. The rest I cannot search for because it changes with each new entry, except the VI is still there. I want to find every string with VI______.
I tried LIKE VI, LIKE VI, = VI, but only one result will show if I search using the entire string.
How can I search a mysql database field for half of a string like that?
(the other half of the string does need to remain in the field, so I can't just take it out.)
