Search exact value on text field.
Posted on 2006-06-07
I have a table with a text field that was once used for notes. Since then, they started updating all the entries in the table and they used the text field to mark the update status.
They used different codes in the text field to indicate the update that was made.
If it didnt need updating they used 'X'.
If partially updated, they used '*'
If fully updated, they used '**'
If they didn't know yet if it needed updating, they used '?'
Now they want a report based on the update status.
Of course we all know if I use:
SELECT * FROM table where textfield LIKE '%*%'
It will result in anything with *. This is not good since I don't want ** records. I just want * records.
How can I make it such that it searches the text field and matches exactly? Not a wildcard method.