Re: Search help
If that's a comma-separated list of values in one column, it's a design error violating a basic rule, atomicity, one value per cell. Fix it.
Otherwise: ... coursename rlike 'b\.?e' will do your match, but it will also match 'Abe Lincoln', so you may have to refine your search logic.
Edited 1 time(s). Last edit at 09/26/2014 10:31AM by Peter Brawley.
Subject
Written By
Posted
September 23, 2014 07:41AM
Re: Search help
September 23, 2014 11:55AM
September 24, 2014 04:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.