Ad
Regular Expressions

Using REGEXP can make the query shorter.

Code
Diff
  • -- Code Here
    SELECT 
      * 
    FROM
      transactions
    WHERE
      customer ~* '^[DE]'
    • -- Code Here
    • SELECT
    • *
    • FROM transactions
    • WHERE Customer LIKE 'D%' OR Customer LIKE 'E%'
    • *
    • FROM
    • transactions
    • WHERE
    • customer ~* '^[DE]'