In some queries, you may not be able to grasp the exact value of the query, such as Baidu search input key words can query out the relevant results, this query is called Fuzzy query.
The fuzzy query uses the LIKE keyword to retrieve the required rows of data through character matching. The wildcard characters "%" and "_" can be used for character matching operations:
%: represents 0 or more arbitrary characters. _: Represents an arbitrary character.
The syntax is: Like ' string ' [ESCAPE ' character ']. The "character" in the matched string, after escape, is used as the escape character.
Wild-Letter Expressions
The ' s% ' string that begins with S.
' _s% ' The second character when S of a string.
'%30\%% ' escape ' \ ' contains a string of "30%", "\" means an escape character, and "\%" represents a character "%" in a string.
Code Demo: Displays the name, salary, and salary of the employee whose name begins with J at the end of S.
<span style= "FONT-SIZE:18PX;" >SQL> SELECT ename,job,sal from EMP WHERE ename like ' j%s ';</span>
Oracle like Fuzzy query