How to use the LIKE keyword in SQL?

sql

Solution

Is this what you're looking for

SELECT *
FROM yourtable
WHERE yourcolumn LIKE 'X%'

This will find all rows where `yourcolumn` starts with the letter X.

To find all that ends with X:

...
WHERE yourcolumn LIKE '%X'

...and contains an X...

...
WHERE yourcolumn LIKE '%X%'

Problem

I want to write an SQL query using the `LIKE` keyword. It should search the first character or the starting character of my column with the search parameter. Is there a specific syntax for doing this?

Original source