select name start with a and end with b

[virendra_sharma]

Hi,
i want to write a query for employee's who's name start with "a" and end with "b".

Thnks in advance :)

[pritaeas]

See WHERE column LIKE

[virendra_sharma]

See WHERE column LIKE

i want to write the query for e.g there a name RICKY now i want a query where name start
with R and end with Y , so that we will get output like RICKY

[simplypixie]

SELECT * FROM table_name WHERE column_name LIKE 'R%' AND colum_name LIKE '%Y'

[pritaeas]

or:

SELECT * FROM table_name WHERE column_name LIKE 'R%Y'