By using the following syntax we return ex character. Illustrate the end result of the above declaration by using the use of the following snapshot.Ĭonsider another example, suppose we need to find those employee names that end with an ex. We use the following statement to find out employee names like bo.Įxplanation: With the help of the above statement, we find those names start with ‘bo’ characters where we use select and where clause to implement the above statement and we return two-column emp_id and emp_name. _(Underscore sign): This sign is used to match any single character.Ĭonsider the above example we need to find out the employee’s name and you do not remember the exact name of the employee, but you remember the first two characters for example bo.%(Percentage sign): This sign is used to match any sequence of character, the character size may be zero or more.So you can use the like an operator that is provided by PostgreSQL. So how can we find the exact name of an employee? You may find names in emp_info tables but it is a time-consuming process. But you remember the first two characters like bo. Suppose we need to find out the employee’s name and you do not remember her exact name. Now see how we can use like operator to find out the matching pattern using the below methods. Illustrate the end result of the above declaration by using the use of the following snapshot. For selecting the table emp_info we will use the following:
0 kommentar(er)
