xxxxxxxxxx
WHERE CustomerName LIKE 'a%'
--Finds any values that start with "a"
WHERE CustomerName LIKE '%a'
--Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'
--Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'
--Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a__%'
--Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'
--Finds any values that start with "a" and ends with "o"
xxxxxxxxxx
-- LIKE is case sensitive pattern matching and ILIKE is case insensitive pattern matching
SELECT *
FROM table_name
WHERE col1 LIKE '__t%' AND col2 NOT ILIKE 'a%t_ ;
xxxxxxxxxx
eturns true if the operand value matches a pattern.
Example: Returns true if the user’s first_name ends with ‘son’.
SELECT * FROM users
WHERE first_name LIKE '%son';
xxxxxxxxxx
@startuml
Class01 <|-- Class02
Class03 *-- Class04
Class05 o-- Class06
Class07 .. Class08
Class09 -- Class10
@enduml
xxxxxxxxxx
@startuml
abstract abstract
abstract class "absgfgw"
annotation annotation
circle circle
() circle_short_form
class class
diamond diamond
<> diamond_short_form
entity entity
enum enum
interface interface
protocol protocol
struct struct
@enduml
xxxxxxxxxx
SELECT employee_id, first_name, last_name
FROM employees
WHERE first_name LIKE 'John%';