SQL Wildcard Characters

SQL TUTORIALS-

SQL Wildcard Characters

Introduction-

-✅SQL wildcards are special characters used with the LIKE operator in the WHERE clause to search for specific patterns in a column.

-✅Symbols in LIKE:- % , _ , [ ] , [^ ] , Example- WHERE name LIKE 'A%' , WHERE name LIKE '_nni' , WHERE name LIKE '[A]mit' , WHERE name LIKE '[^A]mit' ....

🔸 Example Table: Employee

✅ Find names starting with 'A':-

SELECT * FROM Employees WHERE Name LIKE 'A%';

✅Result Show :-

Result → ANNI |

✅ Find names ending with 'n':-

SELECT * FROM Employees WHERE Name LIKE '%n';

✅Result Show :-

Result → SUJAN |

✅ Find names with 'ou' in the middle:-

SELECT * FROM Employees WHERE Name LIKE '%ou%';

✅Result Show :-

Result → BOULT |

✅ Names that are exactly 5 letters.

SELECT * FROM Employees
WHERE Name LIKE '_____';

✅Result Show :-

Result → SUJAN | BOULT |

✅ Names starting with A and ending in 'n' with exactly 4 letters

SELECT * FROM Employees
WHERE Name LIKE 'A__n';

✅Result Show :-

Result → ANNI | SUJAN |

May Be Like Important Link-

-How To Import Data(LSMW) LEGACY SYSTEM MIGRATION WORKBENCH

-Define Condition Type-OBYZ

-Genral Ledger Chart Of Accounts-OBD4

-Document 90039783 saved (no accounting document generated)