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

Thnks in advance :)

See WHERE column LIKE

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

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

or:

SELECT * FROM table_name WHERE column_name LIKE 'R%Y'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.