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

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'
Be a part of the DaniWeb community

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